Quote Originally Posted by Excel Fox View Post
0 is added just to ensure that there are no errors. Everything else can be found out by evaluating the formula. Post back if that's still not clear.
Hi,
I liked your thread but I have a different query.

I have the following data in excel:

Column A Column B
Safe and sound A0001199 Safe
London Cars S0100999 LC
Wembley Motors Q0001988 We
And so on…

In column B, I need to extract A0001199 (in cell B1), S0100999 (in cell B2) and Q0001988 (in cell B3).

Please could you help, how I can extract those data from column A to column B?

Thank you in advance
Firoz