G Guest Oct 21, 2004 #1 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.
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.
C Chip Pearson Oct 21, 2004 #2 Tim, Try =MID(A1,FIND(" ",A1)+1,LEN(A1)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Tim, Try =MID(A1,FIND(" ",A1)+1,LEN(A1)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
G Guest Oct 21, 2004 #4 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 Click to expand...
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 Click to expand...
D Dave Peterson Oct 22, 2004 #5 See another reply at your other post. (especially if your cell contains more than two words.)
