SimonHughes
Active Member
- Joined
- Sep 16, 2009
- Messages
- 485
- Office Version
- 365
- Platform
- Windows
Hello, I have a spreadsheet where the originator has used the Alt+Enter key to have two lines of text in a cell - they are all in column A and there are 355 entries like this. Is there a way to unwind this format so it all appears as one line (from which I can performa text to column action). Many thanks
Main Building - Ground Floor - Above Entrance To Meeting Room 9 |
Hilton hotel - Heathrow - Ground Floor - Outside meeting room 7 |