• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

help with formula

T

tradford

New Member
I am using excel 2010 and I am trying to figure out how to extract on 7 letters of the first name. Example cell A2 = roberts B2 = john b A3 = roberts B3 = patricia a


I need C2 = rjohn and C3 = rpatrici as you can see I need to exclude the space and anything after. This is what I have =LOWER(LEFT(A2,1)&LEFT(B2,FIND(" ",B2))) but it includes the space and initial Please help I am desperate.
 
Tradford


Firstly, Welcome to the Chandoo.org Forums


Try the following in C2

=LOWER(LEFT(A2,1)&LEFT(B2,FIND(" ",B2)-1))

then copy down


If Column B can have an entry without a space try the following in C2

=LOWER(LEFT(A2,1)&IFERROR(LEFT(B2,FIND(" ",B2)-1),B2))

Then copy down.
 
Hi,


Thank you. I did try that, but the problem is that some of the first names are longer than 7 letters, so in the case of patricia I get her entire first name instead of the first 7. I have spent over 9 hours researching excel videos and doing google searches to no avail. I even tried a mid function...... ahhhhhhhhhhhhhh
 
You must log in or register to reply here.
Back
Top