2008/10/29 Guy Voets <[EMAIL PROTECTED]>
> 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
>
Found it! FIND isn't ZOEKEN, but VIND.ALLES
And for those who want to know, MID is DEEL in Dutch.
Is there anywhere a conversion table for Calc Functions?
Thanks Brian!
--
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
