Tags: accent, advance, college, course, create, doc, excel, figure, french, french-english, generator, marks, microsoft, msdn, software, vocabulary-list, vowels

Need accent marks on vowels, for French-English doc. Help?

On Microsoft » Microsoft Excel

3,723 words with 3 Comments; publish: Thu, 22 May 2008 06:46:00 GMT; (30693.75, « »)

Hi & thanks in advance...

I'm trying to create a French 101 vocabulary-list generator, for my college

course, but can't figure out how to input the "special characters". For the

letter E, for instance, I need to apply at least 4 different accent marks to

the vowel. I can do this easily enough in Word 2000, but with Excel 2000,

have searched to no avail! I've tried various different hot-key options, no

go. RATS!

Nevermoore

All Comments

Leave a comment...

  • 3 Comments
    • Hi Nevermoore,

      The simple one-off way is via Insert|Symbol.

      If you're doing a lot of this, you might do well to learn the keyboard codes. Here's a way to find them:

      Put = ROW() in A1 and =CHAR(A1) in A2 & copy both cells down to row 255, you'll get a list of all the characters for whatever font

      you're using. The accented characters you're after will start around row 192. To insert such a character from the keyboard hold down

      the Alt key and type '0' followed by the number in column A. For example, Alt-0224 gives à .

      Cheers

      --

      macropod

      [MVP - Microsoft Word]

      --

      "nevermoore" <nevermoore.excel.todaysummary.com.discussions.microsoft.com> wrote in message news:D2F47D27-8067-4F77-ABB0-525B94CA2E44.excel.todaysummary.com.microsoft.com...

      > Hi & thanks in advance...

      > I'm trying to create a French 101 vocabulary-list generator, for my college

      > course, but can't figure out how to input the "special characters". For the

      > letter E, for instance, I need to apply at least 4 different accent marks to

      > the vowel. I can do this easily enough in Word 2000, but with Excel 2000,

      > have searched to no avail! I've tried various different hot-key options, no

      > go. RATS!

      > Nevermoore

      >

      #1; Thu, 22 May 2008 06:47:00 GMT
    • > I'm trying to create a French 101 vocabulary-list generator, for my

      > college course, but can't figure out how to input the "special

      > characters". For the letter E, for instance, I need to apply at least

      > 4 different accent marks to the vowel. I can do this easily enough in

      > Word 2000, but with Excel 2000, have searched to no avail!

      I don?t know a built-in way as easy as Word's.

      Since you type French a lot, you might consider setting up an auto-correct

      item for each special character.

      For example, I just tried

      Tools > AutoCorrect Options

      and added

      Replace ,e,

      With <Alt>0233

      using the numeric keypad for the four digits

      Now, when I type

      ,e,

      even in the middle of a word I get an accented "e".

      (I have Excel 2003.)

      #2; Thu, 22 May 2008 06:48:00 GMT
    • MyVeryOwnSelf wrote on Sun, 23 Sep 2007 15:36:50 -0500:

      '>> I'm trying to create a French 101 vocabulary-list

      '>> generator, for my college course, but can't figure out how

      '>> to input the "special characters". For the letter E, for

      '>> instance, I need to apply at least 4 different accent

      '>> marks to the vowel. I can do this easily enough in Word

      '>> 2000, but with Excel 2000, have searched to no avail!

      M> I don?t know a built-in way as easy as Word's.

      M> Since you type French a lot, you might consider setting up

      M> an auto-correct item for each special character.

      That's not a bad way to go since Excel does not have the control

      method of Word (ê is CTRL+Shift-6+ e). I wonder why Microsoft

      has never provided that in Excel since it and Word have been

      supposed to be parts of an Office suite for a very long time?

      James Silverton

      Potomac, Maryland

      E-mail, with obvious alterations:

      not.jim.silverton.at.verizon.not

      #3; Thu, 22 May 2008 06:49:00 GMT