Using Excel to Separate info within a Cell

[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

 

[GS]

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

 

[isabelle]

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.

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.

 

[GS]

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.

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