text to excel

Hello friendly excel people 🙂 I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page. What I'm trying to do, is to...

Hey guys, I need your help with this case (sorry for the bad english :) ) I have this TXT file with payment details for each person divided by a line containing the name and year of the record, a new line with CPF number, and columns for each type of record (there are 7 colums, with headers)...

okay, I know this can be done, but i dont know how. I have a huge text file containing data entries like the following. Executive: Name 1 Mobile: 9824209211 Executive: Name 2 Mobile: 9888888888 Company 1 Name Member No: S-133/I/L Category: Food work, Cattle work Year of Established: 1983...

Hi guys, so I have this massive text file that I need to get into Excel. The files is like this in text: Alaska Southcentral Foundation-Alaska Native Medical 315 Diplomacy Drive Anchorage, AK 99508 Program Information: Program: General Practice Residency 24 Months Program Director: Dr...

hi, i m making a utility and want to give import and export data facility. i have made code for export but for coding import data i am in trouble. while exporting data from excel to txt user can use any name or destination of file so it will not defined. can you help me to give a vba code that...

I have .txt files in folder, I need a macro that opens .txt file in excel, run 2 macros and save file in different location and continue the process till all files are completed. All txt files are name as numbers in sequence e.g ( 1.txt, 2.txt........ n.txt)

Hi everyone, Im not good at doing macros and i need anyones help with this problem, i got loads of textfiles to work on and it is much convenient to work with all these files into one excel file, so im thinking of doing a macro with it. At present im doing this stuff manually by loading...