2008/10/29 Harold Fuchs <[EMAIL PROTECTED]>
> 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]
>
>
So, in Dutch, it is =LINKS(A2;VIND.ALLES(" ";A2)-1)
and =DEEL(A2;VIND.ALLES(" ";A2)+1;99)
--
Guy
