Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


DamageInc

556 posts

Ultimate Geek
+1 received by user: 73

Lifetime subscriber

#295690 15-Apr-2022 11:49
Send private message

Hello,

 

When i import reports into excel, i have to create the break lines (to separate the data) each and every time. Is there a way of making these break lines persistent?

 

Any help much appreciated.

 





Pop! OS


Create new topic
ANglEAUT
altered-ego
2436 posts

Uber Geek
+1 received by user: 842

Trusted
Lifetime subscriber

  #2907899 28-Apr-2022 13:48
Send private message

Maybe you need to get @Peppery & @kiwifidget involved again?

 

Using the dialog box you captured in the screenshot, I believe you can't make "the break lines persistent"

 

 

 

Maybe a different approach would be to record this little macro

 

  • Data ribbon > import text file
  • split text unto multiple columns

 





Please keep this GZ community vibrant by contributing in a constructive & respectful manner.


Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.