View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
 
Posts: 132
Default Remove asterisk from column with text only

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!