Text Manipulation

**jcy1011** · 08-02-2010, 01:34 PM

I have a long list of part numbers and need to eliminate a common character in each.

e.g.

asd*123
asd*456
fhsd*54664
sd*34

I want

asd123
asd456
etc without the asterisk

**martindwilson** · 08-02-2010, 01:46 PM

find ~* replace with nothing

**jcy1011** · 08-02-2010, 03:06 PM

Originally Posted by martindwilson

find ~* replace with nothing

you're gonna need to make more idiot proof instructions bc im an excel idiot

i did that and that replaces the entire contents of the cell. I only want to get rid of the * and leave the rest

**ChemistB** · 08-02-2010, 03:10 PM

You need to include the ~ before the *

**Whizbang** · 08-02-2010, 03:41 PM

Originally Posted by jcy1011

you're gonna need to make more idiot proof instructions bc im an excel idiot

i did that and that replaces the entire contents of the cell. I only want to get rid of the * and leave the rest

If you go to "Help" and type "Wildcard" it will give you a basic understanding of what ChemistB means.

This is the online version of the same thing.
http://office.microsoft.com/en-us/ex...005203612.aspx