Remove asterisk from column with text only
Just to add to Sean's response...
If you want to replace an asterisk character, use ~* in the from string.
If you want to replace a question mark, use ~? in the from string.
If you want to replace a tilde (~), use ~~ in the from string.
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!
--
Dave Peterson
|