Thread: how do i delete a * at the end of each word in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default how do i delete a * at the end of each word in a column
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)

"celler6" wrote in message
...
In a column I have all last names followed by * e.g. Jones*
How do I delete the *
Thanks in advance for your help


Reply With QuoteReply With Quote