DELETE ONLY * IN A CELL

  • Thread starter deleting a character
  • Start date
D

deleting a character

I have a bunch of data that has an * before and after data. What is the
easiest way to just delete the * without erasing the data between *XXXX*?
 
R

Ron de Bruin

Select the range

Then use Edit>Replace

Find what : ~*
Replace with : leave empty
 
B

Biff

Try this:

Select the range of cells in question
Goto Edit>Replace
Find what: ~*
Replace with: nothing, leave this blank
Replace All

Biff
 
Top