Pull data out of cell with multiple lines

[dbpowell89]

Hi,

I'm runnnig Excel 2007 in Windows XP. I'm working in a spreadsheet and have a single column of cells and each CELL contains multiple lines of text. I only want to pull out a PART of one of the lines. The line within the cell I need looks like this: Main Phone: ###-###-####. The part I want to extract is only the ###-###-####.

Here is an example of what one CELL within the column looks like:

1234 Red Blue St.
Suite 1234
Washington, DC 12345-1234
United States
Main Phone: 123-456-7890
Main Fax: 123-456-7891


The text is wrapped within the cell. When it is unwrapped there are small blocks that represent the break between lines.

My apologies in advance; I am not able to attach the spreadsheet as it contains confidential information.

Thanks for the help!

 

[c_m_s_jr]

Welcome to the board.

=mid(a1,find(": ",a1)+2,12)

 

[jfish1288]

Might be a round about way but you could use this formula

"=LEFT(RIGHT(B3,35),12)"

 

[jfish1288]

in the above post "B3" is the cell containing the text

 

[dbpowell89]

Thanks a ton, worked like a charm. Have a wonderful day.