deleting info within a cell

  • Thread starter Thread starter jkc
  • Start date Start date
J

jkc

I would like to delete ' and an s in a set of numbers within a cell how do
you efficently do this through out a data set. (example 344'6s = 3446 in
cell only)
 
Hi,
do you always have ' and s in your data if yes highlight the data, press
CTRL H
find what enter ', then in replace with don't enter anything and click on
the replace all button, do the same with the s
 
Back
Top