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 single cell and i am trying to find a way to set up as individual cells for any line of text.

Is there a way to do that?

Thanks in advance

Formulas and Functions

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))

Patrick2788
Silver Contributor
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
  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
    MVP
    May 23, 2023
    Daniel237
    
    As an option, perhaps Power Query with From PDF connector works.

Forum Discussion

Unwrap a wrapped text

Share

Resources