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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a column I have all last names followed by * e.g. Jones*
How do I delete the *
Thanks in advance for your help
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Create a Phone Book using MailMerge in word 2007 0
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
How can I extract each Max key value ? 2
changing the order of text in a string 3
Keeping A Derived Column Of Numbers ? 2
Sumproduct a column where 2 adj text columns contain same value 5
Delete a formula but leave the data. 2
Appending A Column By What's In Another Column ? 1

Back
Top