Thread
:
DELETE ONLY * IN A CELL
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
Posts: 11,123
DELETE ONLY * IN A CELL
Select the range
Then use EditReplace
Find what : ~*
Replace with : leave empty
--
Regards Ron de Bruin
http://www.rondebruin.nl
"deleting a character" <deleting a
wrote in message
...
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*?
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin