Removing characters from cells

K

Kevin M

Mornin' all,
I'm trying to streamline some data that is extracted from
SAP to Excel. It's supposed to do it, but doesn't do it
cleanly. Once extracted you end up with dashes and spaces
in say, a part number. If it was five levels down in SAP
you'll end up with five dashes and some random spaces.
I'd like to write a formula to remove the spaces and
dashes. The first time i did it i ended up using RIGHT,
but it changes because part #'s vary by length.
IE:
-- - -- ABCD1234
to
ABCD1234
TIA
Kevin M
 
K

Kevin M

Frank, one more thing, i'd like to also substitute the
character "|" with "". I managed to mess it up trying to
add it myself.

Thanks again,
Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract characters from Right of string 5
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
remove alpha or non-numeric characters from cell 8
chop off last 5 characters of a string 9
Formula to replace invalid filename characters 2
Removing space characters 2
Remove characters from end of string 3
How can I remove a non-printing character from a cell? 2

Top