GMC The Macro Man
Board Regular
- Joined
- Mar 23, 2023
- Messages
- 64
- Office Version
- 2021
- Platform
- Windows
Hi guys
I am trying to present the TEXT in Cell A2 to look like Cell A3. - Now before you all jump in.... I know it's ALT + Enter after each comma. My question is this. I have 300 Lines in Column A that look like Cell A2 and I don't want to have to go in to every individual cell and press ALT + Enter. I looked at Delimiter but that just wants top split it into separate columns.
Can anyone advise on a way to solve this.
Thanks in Advance
I am trying to present the TEXT in Cell A2 to look like Cell A3. - Now before you all jump in.... I know it's ALT + Enter after each comma. My question is this. I have 300 Lines in Column A that look like Cell A2 and I don't want to have to go in to every individual cell and press ALT + Enter. I looked at Delimiter but that just wants top split it into separate columns.
Can anyone advise on a way to solve this.
Thanks in Advance