| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Macro Help | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Translation Exercise ... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
Hybrid Mode
