| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change SSN to text
This should do it.
=SUBSTITUTE(A1,"-","") "New2EKU" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change SSN to text
Are you sure that the hyphens are there in a text string? Or is it a number
formatted as SSN? -- David Biddulph "New2EKU" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change SSN to text
I need a bit more direction - where do I put the command line? Sorry....
"Mike" wrote: This should do it. =SUBSTITUTE(A1,"-","") "New2EKU" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change SSN to text
If 222-22-2222 is in cell A1 the put this formula =SUBSTITUTE(A1,"-","")
in cell B1 and drag down. "New2EKU" wrote: I need a bit more direction - where do I put the command line? Sorry.... "Mike" wrote: This should do it. =SUBSTITUTE(A1,"-","") "New2EKU" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change SSN to text
If you want to use the replace command, you do it as follows:
1. Highlight the cells you want to change 2. Click EditReplace... 3. Find what: - [the dash character] 4. Replace with: [don't enter anything here] 5. Click Replace All Regards, Fred. "New2EKU" wrote in message ... 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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change SSN to text
Thanks so much - it worked perfectly!
"Mike" wrote: If 222-22-2222 is in cell A1 the put this formula =SUBSTITUTE(A1,"-","") in cell B1 and drag down. "New2EKU" wrote: I need a bit more direction - where do I put the command line? Sorry.... "Mike" wrote: This should do it. =SUBSTITUTE(A1,"-","") "New2EKU" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
