Woody Pecker
New Member
- Joined
- Apr 11, 2008
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
- MacOS
I have information which I need to import from an external company, but when we receive it sometimes there are text contents within a single cell which appear on separate line (shown in the attached picture).
I need a formula that will concatenate this information onto one single line of text, so in this example "COLLECTION. 0 758 207 1156 - CALL BEFORE NO HGV USE SMALLER 25/5/2020" is required.
Regretfully I'm not up to speed on VBA, so formula would be better.
I need a formula that will concatenate this information onto one single line of text, so in this example "COLLECTION. 0 758 207 1156 - CALL BEFORE NO HGV USE SMALLER 25/5/2020" is required.
Regretfully I'm not up to speed on VBA, so formula would be better.