One way, copy and paste the text into notepad first, then copy from notepad
, click in the formula bar of the selected cell and paste it


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"cmmssmith" wrote in message
...
Any suggestions on how I could extract text from multiple cells (in a row)
to
be included in one cell.