Extracting Product Number from Text

[DDM64]

Good morning,

Is there a way to extract the following product number from the description text and place it in a blank column?:

Product Description 741
or
12" Demi Parisian-65

I just need to extract with a Formula, the numbers at the end to a blank column.

Thanks a bunch.

[Kevin UK]

Hi DDM64

Assuming the data is in A1:A2, try the following in B1 and copy down.

Please Login or Register  to view this content.

[thameem127]

try this formula

=getNumber("your cell reference")

[FDibbins]

Thaneem, to the best of my knowledge, no such function exists in 2007 and earlier? Is that perhaps a UDF you created?

[thameem127]

FDibbins,
Yes I admit.Your right. I didn't remember.

[DDM64]

Hello,

Is there a way to extract the following product number from the description text and place it in a blank column?:

Product Description 741
or
12" Demi Parisian-65

Description and Product Number are sharing the same cell and I need to separate them. I need the Product No. ie 741 and 65 to go in their own column to the right. Currently, the Product Description and Product No that are combined are in Column B and I need to extract the Product Number and place them in the next column, which is Column C.

I just need to extract with a Formula, the numbers at the end to a blank column. Maybe nesting a few functions???

Thanks a bunch.

[Marcol]

Why post the same thing twice?

Have you looked at Post #2 ...

[Teethless mama]

=abs(lookup(1e99,-right(a1,row($1:$99))))