ppleasebob
Board Regular
- Joined
- Dec 23, 2002
- Messages
- 145
=LEFT(B11,FIND(" ",B11,1)-1)
returns the text from cell b11 that appears upto the space, in this case it returns the first name of an employee, how can I get it to return the surname (ie after the 1st space(*)), surely substituting LEFT for RIGHT should work.
This one is getting to me a bit, I was given the aforementioned formula by the board - thank you board! but I missed out on the explanation as to what bit does what and why..
please help - I'd like to learn.
oh the (*), I'd like to return Van Helsing from Robert Van Helsing if possible.
returns the text from cell b11 that appears upto the space, in this case it returns the first name of an employee, how can I get it to return the surname (ie after the 1st space(*)), surely substituting LEFT for RIGHT should work.
This one is getting to me a bit, I was given the aforementioned formula by the board - thank you board! but I missed out on the explanation as to what bit does what and why..
please help - I'd like to learn.
oh the (*), I'd like to return Van Helsing from Robert Van Helsing if possible.