| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change first character in a cell
I have a list of +2000 phonenumbers and they are in the format of
012345678 but must become 3212345678, so the first 0 needs to become 32 I searched, but was unable to find a solution. Any idea? houghi -- Theologians can pursuade themselves of anything. Anyone who can worship a trinity and insists that his religion is a monotheism can believe anything -- just give him time to rationalize it. Robert A. Heinlein, JOB: A Comedy of Justice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the character separating thousands or decimals on. | Excel Discussion (Misc queries) | |||
| How to change character to lower case except the first letter? | Excel Discussion (Misc queries) | |||
| How can I change 255 character limit in 'hyperlink' function? | Excel Worksheet Functions | |||
| Change character while copy | Excel Worksheet Functions | |||
| Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Threaded Mode
