| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove asterisk from column with text only
I am using Excel 2003 - I have a spreadsheet which I imported from my Outlook
contacts. Most of the names came over with an "*" at the end and I need to remove it because I am using this list to create labels. When I go into Find & Replace, replace all removes the WHOLE name in the cell. Is there a macro or formula I can use to remove the asterisk? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns - Way to remove all column breaks at one time? | Excel Discussion (Misc queries) | |||
| How to AutoFilter certain cells in a column (in Excel not VBA) for an Asterisk "*" ? | Excel Discussion (Misc queries) | |||
| Remove specific text from a column of cells | Excel Discussion (Misc queries) | |||
| Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
