Forum Discussion

Daniel237's avatar
Daniel237
Copper Contributor
May 18, 2023
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...
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    May 18, 2023

    Daniel237 

    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))
Daniel237's avatar
Daniel237
Copper Contributor
May 23, 2023

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 23, 2023

Daniel237 

As an option, perhaps Power Query with From PDF connector works.

Resources