Prev: Use Find and Replace in Excel
Next: How do I show all words in a cell?
From: Ms-Exl-Learner on 5 May 2010 12:10
Assume that you are having the data in A1 cell.

Copy the below formula and paste it in C1 cell.
=IF(A1="","",TRIM(MID(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1),"
","^",LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ","")))),255)))

Copy the below formula and paste it in D1 cell.
=IF(A1="","",TRIM(LEFT(TRIM(A1),FIND("^",SUBSTITUTE(TRIM(A1),"
","^",(LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))))))))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Kiley" <Kiley(a)discussions.microsoft.com> wrote in message
news:53DC9CD1-DEC8-46D7-AC58-B549AB7EC9F5(a)microsoft.com...
> I have a list of names in colum B, that I would like to split into column
> C
> and D. The names in column B have a first name, middle intial and a last
> name. I would like the last name to go into column c and the first name
> and
> middle initial to go into column D.
>
> Column B Column C Column D
> Mary A Jones Jones Mary A

First  |  Prev  | 
Pages: 1 2
Prev: Use Find and Replace in Excel
Next: How do I show all words in a cell?