Change SSN to text

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

If you want to use the replace command, you do it as follows:
1. Highlight the cells you want to change
2. Click Edit>Replace...
3. Find what: - [the dash character]
4. Replace with: [don't enter anything here]
5. Click Replace All

Regards,
Fred.

"New2EKU" <(E-Mail Removed)> wrote in message
news:CF05FC0A-2BE4-4333-AB11-(E-Mail Removed)...
> 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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change background color in one text box based on text in 2nd text	Gnerks	Microsoft Access Reports	4	4th Aug 2008 02:52 PM
Change status bar text back to default 5 seconds after every change?	sherifffruitfly	Microsoft C# .NET	4	13th Nov 2006 10:59 PM
Don't change new message Attachment position when text type change	=?Utf-8?B?QmlsbC1S?=	Microsoft Outlook Discussion	1	3rd Aug 2005 01:42 AM
Change of text or background color doesn't change on the screen.	=?Utf-8?B?U3VzYW4=?=	Microsoft Excel Misc	5	29th Jul 2005 07:18 PM
Track change pasting as text without change in format	tromoskaifobos	Microsoft Word Document Management	1	4th Nov 2003 08:33 AM