G Guest Feb 10, 2007 #1 In a column I have all last names followed by * e.g. Jones* How do I delete the * Thanks in advance for your help
In a column I have all last names followed by * e.g. Jones* How do I delete the * Thanks in advance for your help
C Chip Pearson Feb 10, 2007 #2 Use Replace, and put ~* in the Find What box. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site)
Use Replace, and put ~* in the Find What box. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site)
