Using Excel to Separate info within a Cell

  • Thread starter Thread starter CarsonY
  • Start date Start date
C

CarsonY

Hi there,
I am looking for some help to strip part of a cell and leave only the portion of text I need.
My situation is a large Product Sheet which has item Sku and Descriptions together in one cell eg - CE513 (ProExpress)
I am hoping to strip away the description portion -(ProExpress) so that I have a new column which reads only the SKU - CE513

I know this is possible, but cannot figure it out. Please help if you know how, the table has hundreds of items and will take me forever to do this manually each time I need it.

Thanks
-CarsonY
 
Assuming your product items are listed in colA, put the following
formula in the target col where you want the SKUs listed...

=LEFT($A1,FIND(" ",$A1)-1)

...which assumes the delimiter between SKU and Description is a space
character.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
hi Carson,

also, if there are a space on the left string part

=LEFT($A1,FIND("(Pro",$A1)-1)

isabelle

Le 2013-09-13 16:59, CarsonY a écrit :
Hi there,
I am looking for some help to strip part of a cell and leave only the portion of text I need.
My situation is a large Product Sheet which has item Sku and Descriptions together in one cell eg - CE513 (ProExpress)
I am hoping to strip away the description portion -(ProExpress) so that I have a new column which reads only the SKU - CE513

I know this is possible, but cannot figure it out.
Click to expand...

Please help if you know how, the table has hundreds of items and will
take me forever to do this manually each time I need it.
 
hi Carson,
also, if there are a space on the left string part

=LEFT($A1,FIND("(Pro",$A1)-1)

isabelle

Le 2013-09-13 16:59, CarsonY a écrit :

Please help if you know how, the table has hundreds of items and will
take me forever to do this manually each time I need it.
Click to expand...

That assume *every* product description begins with "(Pro"!<g>

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top