Does anyone have a means to remove hyphens from a text or number formatted cell(eg AVE 68-391 or AAG 777-7777). Thanks.
Does anyone have a means to remove hyphens from a text or number formatted cell(eg AVE 68-391 or AAG 777-7777). Thanks.
Hi,
With a helper column.
Assume data in Col A enter this in B1
=SUBSTITUTE(A1,"-","")
and drag down. Copy and then paste special values.
Or Select the column and press Ctrl + H. In the Find box enter - and in the replace box leave blank. Select replace all
HTH
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
If it is text, use:
=SUBSTITUTE(A1,"-","")
If it is a special format (e.g. SSN), then just change the formatting to General (or other format as needed).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks