Hi,
How can I extract a word from a cell when the word I want to extract is
always 2 spaces away starting counting spaces from the right.

Example:
Cell A1: Car, black 66,00 52,80
The word I want to extract is "Car, black"
Formula to be used in cell A2?
Or perhaps a macro?

Thank you in advance.

Kaj Pedersen

---
Denne e-mail blev kontrolleret for virusser af Avast antivirussoftware.
http://www.avast.com