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?
--
Guy
using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger
and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard
-- please reply only to [email protected] --
Dodoes can't afford to have headaches
