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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do i delete a * at the end of each word in a column (https://www.excelbanter.com/new-users-excel/130120-how-do-i-delete-%2A-end-each-word-column.html)

celler6

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

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

Chip Pearson

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

Teethless mama

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

=SUBSTITUTE(A1,"*","")
or
=LEFT(A1,LEN(A1)-1)

"celler6" wrote:

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

All times are GMT +1. The time now is 08:59 PM.