Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change SSN to text
I've read the various messages about how to remove the "-" in a list of SSNs,
using the replace command, but I cannot get it to work. I have a list of SSNs that I need to convert to a string......222-22-2222 needs to be 222222222. Can someone help me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
change the text in the legend of a chart w/o changing pivot text | Charts and Charting in Excel | |||
How can I change text to proper text in multiple cells. | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL | Excel Worksheet Functions |