On 29/10/2008 15:49, Guy Voets wrote:
2008/10/29 Brian Barker <[EMAIL PROTECTED]>
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
Hello Brian,
I must be doing something wrong, because =LINKS(A2;ZOEKEN(" ";A2)-1) in B2
(if that is the right Dutch transcription) gives me a 504 error - same for
the MID formula
Any idea what's wrong?
My English => Dutch dictionary gives, for FIND: vinden, ontdekken,
terugvinden.
My Dutch => English dictionary gives, for ZOEKEN: look for, search for.
Groetjes.
**
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
