Whatever = Left$(Whatever,11)
For the right - Guess, that's right ...=Right$(Whatever,2)


--
Regards;
Rob
------------------------------------------------------------------------
"Gaston " wrote in message
...
Woah. That was the problem. Wasn't recognizing spaces. Thanks a
million.

However, I just have two minor problems now. The string I want to
extract from the cell needs to be the first 11 characters. How do I
just chose, say the first 11 characters and discard the rest?

Also, if I want to get the last two characters of a 3 character
string,
how do I do this as well?


---
Message posted from http://www.ExcelForum.com/