Try this:

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

Biff

"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*?