Removing characters from cells

  • Thread starter Thread starter Kevin M
  • Start date Start date
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
 
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
 
Back
Top