Remove asterisk from column with text only
You can use ~* to find an actual asterisk.
So Find ~* replace with and leave blank.
Alternately, you can have a helper column that will be LEFT(A2,len(A2)-1),
copy down to bottom, then copy and paste special/values on top of yoru name
column.
First way may be a lot easier and quicker.
"Anna" wrote:
I am using Excel 2003 - I have a spreadsheet which I imported from my Outlook
contacts. Most of the names came over with an "*" at the end and I need to
remove it because I am using this list to create labels.
When I go into Find & Replace, replace all removes the WHOLE name in the
cell. Is there a macro or formula I can use to remove the asterisk?
Thanks!
|