| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add dashes to a string?
I have a column of thext in Excel that is
111222333 or 111222333L And want to convert it so that it reads 111-222-333 or 111-222-333L I have applied "=TEXT(A1, "000-000-000")" and have the format "111-222-333" but when the original string has an "L" on the end, it's not included. How can I reformat and preserve the L when it is in the original string? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What are dashes for | Excel Discussion (Misc queries) | |||
| Add Dashes within aText String | Excel Discussion (Misc queries) | |||
| Stripping the dashes | Excel Discussion (Misc queries) | |||
| using dashes and the arrow key | Excel Discussion (Misc queries) | |||
| dashes in vlookup | Excel Worksheet Functions | |||
Threaded Mode
