Excel

Montana Man
Montana Man used Ask the Experts™
on
In Excel 2010 i have a colum that has names like Mike, Mike E. Mike E. Jones, etc  i would like to strip off everything after a space, if a space does not exsist to use what is in there.  
Robert  F
Michael E.  "Mike"
Maryeann
Stephen

So in this example it would return a Robert, Michael, Maryeann, Stephen in the new column.  Also, I want to combine 3 columns into one new one only using the first 4 characters in the last column.  Example:
Bolan      Jared      19890705

So the new column would contain: bolanJared1989
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2012

Commented:
If your names are in column a, starting in A2, you can strip off everything space and after using:

=LEFT(A2,IFERROR(FIND(" ",A2)-1,LEN(A2)))

and copy down

Dave
Montana ManDigital Leader

Author

Commented:
Perfect for the part of the question, how about the second?  Thanks!!
Most Valuable Expert 2012
Top Expert 2012
Commented:
Ok.  If THAT data is in A2, B2, and C2, then you can use:

=A2&B2&LEFT(C2,4)

Dave

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial