import text and sort data into excel
I am trying to take a txt file and is able to import it but then the info is
in 1 column underneath each other but i want to divide it into 5 different columns.The info is large over 800 companies divided by name,adress,city,state and telephone number.I want to divide that info into 5 respective columns.I have tried and concateante and then divide it without success. Help will be greatly appreciated |
All times are GMT +1. The time now is 11:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com