For example pressing Ctrl and Shift plus ^ (caret, usually above the 6 key) then the letter ‘a’ will produce an a with caret above it eg â. An easy way to remember them is … you hold the Ctrl and Shift keys down while pressing the character that represents the type of accent you want. The shortcuts have been there for a long time and the main four are quite logical.

Same with fiance becoming fiancé ShortcutsĬommon accents have shortcuts in Office generally (Word and Outlook which uses Word as its email editor). Type cafe and Office will change it to café In English language versions of Office you’ll probably see some of these: Sometimes you don’t have to do anything! Office may add some accented characters for you automatically using the in-built AutoCorrect list. This ensures you get it right and saves having to work out the keyboard shortcuts to make an accent letter. The real easy way, especially with names, is to copy the word (with accented characters) from some source document or incoming email. Office and Windows let you enter almost any character. It’s good to get a name or word exactly right, if only as a courtesy to the reader. The keyboards don’t show accented letters and it’s not obvious how to type them. Typing accented letters can be a chore and a mystery, especially for those of us unaccustomed to languages with the ‘extra’ letters. Each cell in the selection is evaluated and, if appropriate, modified.How to enter accented characters, grave, circumflex, umlaut etc when they aren’t on the keyboard. To use the macro, simply select the cells you want to change and then run it. The following is a good example of a short macro to do the trick:

The other option is to use a macro to do the replacement. You can copy the formula down as many cells as you need, then copy the results and use Paste Special to paste the values back into the original column.

There are many variations on such a formula, with the following being one & MID(A1,2,LEN(A1)),A1) The first method is to use a formula to remove the tilde. There are two ways you can approach the problem. In that case, you would simply search for ~~ (note that this is two tildes in a row) and replace with However, since you want to replace just a tilde appearing in the first character position, Find and Replace won't do it for you. She's not sure how to perform this task using Find and Replace.Įxcel's Find and Replace would be a good choice if you wanted to replace all tildes in your text. She would like to change the tilde to a different character (such as an sign), but only if the tilde is at the beginning of the cell. Karen has a large number of cells that have a tilde character (~) at the beginning of the cells.

How to add a tilde in word 2010