Parsing Text Strings

[mbshafe]

I have a number of text strings that I had to copy and paste in from a PDF file. There is zero consistency between strings, for instance:

NEW YORK A&P #70207 GOLD RIDGE 75.66
IMPERIAL WOK SUMMERS 55.15

I'm trying to figure out a way to split the strings apart so that I'm left with the description in one column and the price (i.e. 75.66, 55.15, etc) in another column. Any ideas? Thanks, Mike

 

[Andrew Poulsom]

Try:

=LEFT(A1,FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1)

=LOOKUP(9.99999999999999E+307,RIGHT(A1,ROW(INDIRECT("1:"&LEN(A1))))+0)

 

[njimack]

Excel Workbook
	A	B	C
1	RAW DATA	DESCRIPTION	PRICE
2	NEW YORK A&P #70207 GOLD RIDGE 75.66	NEW YORK A&P #70207 GOLD RIDGE	75.66
3	IMPERIAL WOK SUMMERS 55.15	IMPERIAL WOK SUMMERS	55.15
Sheet1

 

[mbshafe]

Thanks...this is fantastic!!!

 

[Scott Huish]

Excel Workbook
	A	B	C
1	NEW YORK A&P #70207 GOLD RIDGE 75.66	NEW YORK A&P #70207 GOLD RIDGE	75.66
2	IMPERIAL WOK SUMMERS 55.15	IMPERIAL WOK SUMMERS	55.15
Sheet1