Extracting Text

Guest · Oct 21, 2004

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.

Chip Pearson · Oct 21, 2004

Tim,

Try

=MID(A1,FIND(" ",A1)+1,LEN(A1))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Bob Phillips · Oct 21, 2004

=MID(A1,FIND(" ",A1,1)+1,255)

Guest · Oct 21, 2004

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

Dave Peterson · Oct 22, 2004

See another reply at your other post.

(especially if your cell contains more than two words.)

Can I extract the only second word?	6	Mar 19, 2010
data from multiple files: best way to extract	1	Apr 21, 2013
Extract specific information from the body of outlook mail to an Excel File using VBA	0	Apr 12, 2017
extract word before /	3	Apr 9, 2009
How to filter rows data based on background color of individual cells	1	Dec 4, 2013
problem with fractions to decimal	1	Sep 28, 2014
extract text between 2 tags	2	Jul 23, 2009
how do I extract the last three digits from each cell in column?	4	Nov 28, 2009

Extracting Text

Guest

Chip Pearson

Bob Phillips

Guest

Dave Peterson

Ask a Question

Similar Threads