Extracting data from a string

[Robz19]

Using "BACARDI SINGLE 000000000000000148" as an example, could someone give me the code in Excel 2007 to extract "BACARDI SINGLE" from the string. I'm looking to extract any information to the left of the 8 spaces.

Thanks

[DGagnon]

i cant see 8 spaces in your example, probably due to formating, but try

Please Login or Register  to view this content.

[Pete_UK]

Using "BACARDI SINGLE 000000000000000148" as an example, could someone give me the code in Excel 2007 to extract "BACARDI SINGLE" from the string. I'm looking to extract any information to the left of the 8 spaces.

Thanks

The 8 spaces do not show up on the forum, though I can see them by quoting your post.

You can do this:

=LEFT(A1,SEARCH("........",A1)-1)

I've put quote tags around the formula so the spaces will not be trimmed.

Hope this helps.

Pete

EDIT: even that didn't stop them from disappearing, so I've put full-stops in instead - use spaces in your workbook.

Pete

[Robz19]

The 8 spaces are between the word SINGLE and the numeric. I have tried that, but return a #VALUE! error.

[DGagnon]

can you privde a few lines of samples in an excel workbook format?

[Robz19]

Fabulous. Thank you Pete.