Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2020, 09:35 PM
Bo_Knows_04 Bo_Knows_04 is offline Convert .txt to .xls Windows 7 64bit Convert .txt to .xls Office 2016
Novice
Convert .txt to .xls
 
Join Date: Jan 2018
Posts: 4
Bo_Knows_04 is on a distinguished road
Default Convert .txt to .xls

Hello,
I have a .txt file that’s exported when a report is ran.
I’m needing to convert this .txt file into .xls and
I need to make sure the data gets converted into
Certain lines and columns during the conversion


Process.

If I submitted a example of the txt and of what the xls file
needs to look like after the conversion, could you please help
Me to code the conversion?

Thanks
Reply With Quote
  #2  
Old 07-12-2020, 10:10 AM
Logit Logit is offline Convert .txt to .xls Windows 10 Convert .txt to .xls Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
Excel includes a Text To Columns feature on the DATA TAB.

Experiment with that as it should attain the goal you are seeking.
Reply With Quote
  #3  
Old 07-13-2020, 02:42 AM
Purfleet Purfleet is offline Convert .txt to .xls Windows 10 Convert .txt to .xls Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

as Logit says Text to columes is brilliant for a number of things, and very intuitive.


But feel free to upload,. happy to have a look
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert .txt to .xls Macro to convert table to convert table into iCalendar file? Weboh Word VBA 5 12-10-2016 03:07 PM
Convert .txt to .xls How to convert 8 1/2 x 11 to A4 GrantSaw Word 3 01-28-2015 11:04 AM
How do you convert to .MOV? pmr8888 PowerPoint 0 11-30-2011 04:32 PM
Convert .txt to .xls How to convert PDF to jpg? gonner Outlook 1 10-28-2011 06:25 PM
convert golden039 Word 0 08-16-2009 05:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft