using data from 2 cells

[Louise]

Dear all

I have a column containing people's names and in another column I need to
re-enter their name but only with the first letter of their forename and the
whole of their surname.

For example, in A1 I have Karen Jones. In cell B1, I need to enter kjones
(in lower case preferably).

Is there a formla I can use to do this, or do I have to type them
individually?

Thank you.
louise

[Hans Knudsen]

=LOWER(LEFT(A1,1)&LOWER(MID(A1,FIND(" ",A1,1)+1,255)))
should work for one surname, but for example George Walker Bush will appear as: gwalker bush. Do you want this as gwalkerbush?

Hans


"Louise" <[email protected]> skrev i en meddelelse news:[email protected]...
> Dear all
>
> I have a column containing people's names and in another column I need to
> re-enter their name but only with the first letter of their forename and the
> whole of their surname.
>
> For example, in A1 I have Karen Jones. In cell B1, I need to enter kjones
> (in lower case preferably).
>
> Is there a formla I can use to do this, or do I have to type them
> individually?
>
> Thank you.
> louise

[Louise]

Hello
Thanks very much for this, it will save me loads of time!

Yes, I would want it to appear as gwalkerbush...

Louise

"Hans Knudsen" wrote:

> =LOWER(LEFT(A1,1)&LOWER(MID(A1,FIND(" ",A1,1)+1,255)))
> should work for one surname, but for example George Walker Bush will appear as: gwalker bush. Do you want this as gwalkerbush?
>
> Hans
>
>
> "Louise" <[email protected]> skrev i en meddelelse news:[email protected]...
> > Dear all
> >
> > I have a column containing people's names and in another column I need to
> > re-enter their name but only with the first letter of their forename and the
> > whole of their surname.
> >
> > For example, in A1 I have Karen Jones. In cell B1, I need to enter kjones
> > (in lower case preferably).
> >
> > Is there a formla I can use to do this, or do I have to type them
> > individually?
> >
> > Thank you.
> > louise
>
>
>

[Hans Knudsen]

=SUBSTITUTE(LOWER(LEFT(A2,1)&LOWER(MID(A2,FIND(" ",A2,1)+1,255)))," ","")

Hans



"Louise" <[email protected]> skrev i en meddelelse news:[email protected]...
> Hello
> Thanks very much for this, it will save me loads of time!
>
> Yes, I would want it to appear as gwalkerbush...
>
> Louise
>
> "Hans Knudsen" wrote:
>
>> =LOWER(LEFT(A1,1)&LOWER(MID(A1,FIND(" ",A1,1)+1,255)))
>> should work for one surname, but for example George Walker Bush will appear as: gwalker bush. Do you want this as gwalkerbush?
>>
>> Hans
>>
>>
>> "Louise" <[email protected]> skrev i en meddelelse news:[email protected]...
>> > Dear all
>> >
>> > I have a column containing people's names and in another column I need to
>> > re-enter their name but only with the first letter of their forename and the
>> > whole of their surname.
>> >
>> > For example, in A1 I have Karen Jones. In cell B1, I need to enter kjones
>> > (in lower case preferably).
>> >
>> > Is there a formla I can use to do this, or do I have to type them
>> > individually?
>> >
>> > Thank you.
>> > louise
>>
>>
>>