how do i delete a * at the end of each word in a column

C

celler6

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

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)
 
Top