Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

deleting excel data 1

Status
Not open for further replies.
cmorales

cmorales

Instructor
Oct 18, 2002
22
0
0
US
Need help deleting partial data from an excel field.
Here is is my field...

SSN
123-45-6789

SSN
123456789

I need to remove the hyphens from 500 records.
 
Sort by date Sort by votes
Is it EVERY single record in the sheet? or are there other hyphens flying about!
If the're not any more... then couldn't you use "Find and Replace" on the edit menu?
Find - replace with nothing?

Just a thought

luds
 
Upvote 0 Downvote
actually.. even if there are other hyphens about.. you could just select the specific data first.. and then do a find and replace on that!
 
Upvote 0 Downvote
Try:

=SUBSTITUTE(A1,"-","")

And copy down!

:)



Peace! [peace]

Mike

Never say Never!!!
Nothing is impossible!!!
 
Upvote 0 Downvote
Thank you all for the information.

The find & replace worked!

 
Upvote 0 Downvote
WOW!!! My first stars!! lol

Thanks cmorales :¬)

luds
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
143
combo
combo
Bijugate
  • Question
Excel update question
Replies
0
Views
104
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
132
combo
combo
kwbMitel
  • Locked
  • Question
Lost edited data in Excel File
Replies
3
Views
85
Scott24x7
Scott24x7
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
152
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top