At 15:34 29/10/2008 +0100, Guy Voets wrote:
I have a column with first and family names. The first name is
always a single word, the family name may be 1, 2 or 3 words. I want
a column with the first names, and another with the family names. So
it's something like: get content of cell until the first space / get
content from cell after the first space. How is it done?
This is in a spreadsheet, right? Here's one way. With the names in
A, in B put
=LEFT(An;FIND(" ";An)-1)
and in C put:
=MID(An;FIND(" ";An)+1;99)
You may have to modify these formulae if there is any possibility
that the original cell may be empty or not include a blank.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
