Forum Discussion
Solved
Unwrap a wrapped text
Hi Guys, I have this file that i converted from PDF to excel...and it's a bit messy. How do i change this wrapped text into individual lines. As you can see below, every lines here are in one...
The simplest solution may be to put in a new column and use something like this to split on the line breaks:
=TEXTSPLIT(B2,,CHAR(10))
The simplest solution may be to put in a new column and use something like this to split on the line breaks:
=TEXTSPLIT(B2,,CHAR(10))Patrick2788Thanks Patrick. it does the job. Just that it stores numbers as text so i had to use =value to sort it out... But all good.
Thanks again
As an option, perhaps Power Query with From PDF connector works.
- You are welcome!
