Drop?

  • Thread starter Thread starter tracy
  • Start date Start date
T

tracy

Hello,

I have a list of skus that I need to eliminate the middle
text information. For example, the sku may be 1524WH3XL

I would like to drop the WH part from the string of
characters. Can anyone help me out with this? Thank you!
 
Is it always the 5th and 6th character from the left? if so you could use

=SUBSTITUTE(A1,MID(A1,5,2),"")

where A1 holds the string, copy down or across and copy and paste special as
values
when you care done
 
There may be a better way to do this but you could use a couple of columns
off to the side and use a Left command and a Right command. to get the text
to the left and right of the part that you want out. then you can use the
Concatenate command to put the 2 strings back together. This will only work
it the original strings are all of the same length and the text that you
want out is in the same place in the text string.
 
Thank you, this is great!
-----Original Message-----
Is it always the 5th and 6th character from the left? if so you could use

=SUBSTITUTE(A1,MID(A1,5,2),"")

where A1 holds the string, copy down or across and copy and paste special as
values
when you care done





--

Regards,

Peo Sjoblom


you!


.
Click to expand...
 
Back
Top