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? |
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? |
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? |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 04:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com