T
Tim
How can I extract the second word in a cell into a cell by itself? I don't
want the first word to go with it into the new cell.
want the first word to go with it into the new cell.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Tim,
Try
=MID(A1,FIND(" ",A1)+1,LEN(A1))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Try
=MID(A1,FIND(" ",A1)+1,LEN(A1))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
B
Bob Phillips
=MID(A1,FIND(" ",A1,1)+1,255)
T
Tim
Thank you very much. It worked perfectly!!
Chip Pearson said:Tim,
Try
=MID(A1,FIND(" ",A1)+1,LEN(A1))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
D
Dave Peterson
See another reply at your other post.
(especially if your cell contains more than two words.)
(especially if your cell contains more than two words.)