| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting the apostrophe
Hello:
In a column of Excel cells, I have the following character mask: 0000-0000-000-000- The first character has an apostrophe in front of it. I want to create a column to the right that has these characters and in the above format but without the apostrophe that appears at the beginning. What formula can I use to accomplish this? Thanks! childofhte1980s |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Always have apostrophe | Excel Discussion (Misc queries) | |||
| Apostrophe Mayhew | Excel Worksheet Functions | |||
| Apostrophe | Excel Programming | |||
| Add apostrophe | Excel Worksheet Functions | |||
| Add apostrophe | Excel Programming | |||
Threaded Mode
