How to remove dashes in Social Security number
John - That works but it drops any leading zeros,
plus I am in the Air Force and they don't like Macros
running on their system without them proofing them.
How can I get Jacob's suggestion to work ?
Thanks
"john" wrote:
Jacobss method easiest but if you want macro following should work.
I have used Column D but you will need to amend as required
Sub ReplaceDashes()
Columns("D:D").Replace What:="-", _
Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False, _
SearchFormat:=False, _
ReplaceFormat:=False
End Sub
--
jb
"George" wrote:
Each month I receive an excel spreadsheet and one of the columns has social
security numbers with the dashes. I have to import it into Access without the
dashes, how can I remove the dashes from the social security numbers in Excel
- without doing it by hand ? Is there a way to use format cells to clear the
dashes ?
Thanks
|