tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I'm not sure if this is easy or difficult to sort out?
I have a list of companies, the data is all in one cell but on separate lines as shown below,
I would like a formula to Pull the First Line of data from the cell and another formula the pulls all but the first line of data from the cell?
any ideas how I can do this?
Example of data:
<COLGROUP><COL style="WIDTH: 176pt; mso-width-source: userset; mso-width-alt: 8557" width=234><TBODY>
</TBODY>So as above I'd like to Separate the Red Data from the Black?
Please help if you can
Thanks
Tony
I'm not sure if this is easy or difficult to sort out?
I have a list of companies, the data is all in one cell but on separate lines as shown below,
I would like a formula to Pull the First Line of data from the cell and another formula the pulls all but the first line of data from the cell?
any ideas how I can do this?
Example of data:
PBK Architects 14001 N. Dallas Pkwy, Ste 400 Dallas, Texas 75240 972-233-1323 |
SHW Architects, LLP 5717 Legacy Dr, Suite 250 Plano, Texas 75024 214-473-2400 |
Corgan Associates, Inc. 401 N Houston Street Dallas, Texas 75202 214-748-2000 |
PBK Architects 14001 N. Dallas Pkwy, Ste 400 Dallas, Texas 75240 972-233-1323 |
<COLGROUP><COL style="WIDTH: 176pt; mso-width-source: userset; mso-width-alt: 8557" width=234><TBODY>
</TBODY>
Please help if you can
Thanks
Tony