Delete asterik mark

  • Thread starter Thread starter da
  • Start date Start date
D

da

Hi
Is there anyway I can delete the asterik mark in front of the ID#? I have
over 1200 ID#s with asterik mark.
Thank you

ID #
* 765
* 4059
* 4793
* 2638
* 5302
* 5494
* 4057
* 5311
* 4823
* 5607
* 1276
* 5413
* 2585
* 5659
* 4001
* 5645
* 2217
* 4054
* 2265
* 2105
 
you should be able to use Edit Find/Replace:

in the Find box put: *
leave the replace box blank
 
Use the 'Find and Replace' option

--Select the column/range and hit Ctrl+H
--Hit 'Options' in Find/Replace window.
--Make sure you select 'Formulas' in 'Look In'
--Find What: ~*
--Replace With: (leave this blank)
--Hit Replace All

If this post helps click Yes
 
Say your ID's in Col A. Insert a helper column next to it. Enter
=RIGHT(A1,LEN(A1)-2), and copy down. Block the new ID's, copy and Paste
Special as values. Delete Col A.

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top