Cell Editing Problem

  • Thread starter Thread starter ngittens
  • Start date Start date
N

ngittens

I am trying to edit a group of cells, all the cells contain USD and
number example(USD 62.49). I would like to remove "USD" and keep th
number. Is their an easy way of doing this without manual deleting th
USD in all 120 cells
 
Choose Edit/Replace. Enter "USD " (without quotes) in the Find box,
Leave the Replace with box blank. Click Replace All.
 
Select the cells, press Ctrl-H, enter USD followed by a space in the top
"Find What" box, make sure the "Replace With" box is empty, and press
Replace All.

HTH,
Bernie
MS Excel MVP
 
Back
Top