software

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

=LOWER(LEFT(A1,1)amp;LOWER(MID(A1,FIND(quot; quot;,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?

Hansquot;Louisequot; gt; skrev i en meddelelse ...
gt; Dear all
gt;
gt; I have a column containing people's names and in another column I need to
gt; re-enter their name but only with the first letter of their forename and the
gt; whole of their surname.
gt;
gt; For example, in A1 I have Karen Jones. In cell B1, I need to enter kjones
gt; (in lower case preferably).
gt;
gt; Is there a formla I can use to do this, or do I have to type them
gt; individually?
gt;
gt; Thank you.
gt; louise
Hello
Thanks very much for this, it will save me loads of time!

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

Louise

quot;Hans Knudsenquot; wrote:

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

=SUBSTITUTE(LOWER(LEFT(A2,1)amp;LOWER(MID(A2,FIND(quot; quot;,A2,1) 1,255))),quot; quot;,quot;quot;)

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