Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jean
 
Posts: n/a
Default social security numbers

How do I change social security numbers so that all the dashes are removed?
thank you for your help in advance.
Jean
  #3   Report Post  
Jean
 
Posts: n/a
Default

Thank you, I did look there first but cannot understand how to convert the
format from dashes to no dashes, even after looking at that section of the
help. I have 800 records to convert and do not want to have to go in and
delete all the dashes if I can do it an easier way!

"Don Guillett" wrote:

Have a look in HELP for SUBSTITUTE

--
Don Guillett
SalesAid Software

"Jean" wrote in message
...
How do I change social security numbers so that all the dashes are

removed?
thank you for your help in advance.
Jean




  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe just select the range with the SSNs with dashes and

Edit|replace
what: - (hypen)
with: (leave blank)
replace all

Then format it as a SSN (format|cells|number Tab|special|SSN)

as a formula that returns text:
=substitute(a1,"-","")
or as a formula that returns a number:
=--substitute(a1,"-","")



Jean wrote:

Thank you, I did look there first but cannot understand how to convert the
format from dashes to no dashes, even after looking at that section of the
help. I have 800 records to convert and do not want to have to go in and
delete all the dashes if I can do it an easier way!

"Don Guillett" wrote:

Have a look in HELP for SUBSTITUTE

--
Don Guillett
SalesAid Software

"Jean" wrote in message
...
How do I change social security numbers so that all the dashes are

removed?
thank you for your help in advance.
Jean





--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sort names and social security numbers a to z olajune1 Excel Worksheet Functions 2 February 25th 05 01:31 PM
Converting Numbers to Text properly Shirley Munro Excel Discussion (Misc queries) 1 February 16th 05 04:01 PM
How can I compare 2 sets of Social Security #'s and Identify dupes vwwolfe Excel Discussion (Misc queries) 1 February 3rd 05 11:08 PM
(social security number) 000-00-0000 to 000000000 Cucuaq Excel Discussion (Misc queries) 1 January 29th 05 02:35 AM
social security sorting Precious Pearl Excel Worksheet Functions 4 January 25th 05 03:37 PM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"