Free Microsoft Excel 2013 Quick Reference

Convert Notepad to Excel

I am trying to convert a report in notepad to excel. I have attached the actual report and a sample of the excel file format that it needs to be in. If anyone can guide me through this I would really appreciate it.


Post your answer or comment

comments powered by Disqus
Hi friends,

I need some urgent help.
I need to import data from notepad to excel and filter the data
according to certain conditions.

I know how to import notepad file to excel, but how to filter the data
is not known.
Could you guys help me out.

thanks in advance.


Was wondering if there is a way to convert XML to excel format. I want to do this using VBA as I have data supplied to me in XML format and want to place it in a spreadsheet.

If anyone knows of a good source of information on this or a good book that explains this kind of thing it would certainly be useful.

Thanks in advance.

Hi Team,

I just wanted to know do we have a macro which can convert PDF to excel......?

Any help Would be greatly appreciated.

Thanks & regards,
Shekar Goud.

Is there a way to convert Notepad (columns and rows) data into mutliple Excel columns and rows within one worksheet?

When I copied and pasted, all of the information from the columns in the Notepad were pasted into one long Excel cell (instead of many), as I figured they might be.

I don't think there is a way around this, but I would greatly appreciate it if someone has a suggestion!


Sometimes i need to check the data from text file in notepad with my data in excel.

The text file is very difficult to read. I wonder is there a way to convert it to excel so that i can compare like to like.


MA1 4.056 5/26/2011 9:53:51 AM
Pressure 0.03 FALSE 5/26/2011 9:53:52 AM
MA2 4.056 5/26/2011 9:53:52 AM
4.056 5/26/2011 9:53:52 AM
0.18 FALSE 5/26/2011 9:53:54 AM
4.056 5/26/2011 9:53:54 AM
4.056 5/26/2011 9:53:54 AM
0.03 FALSE 5/26/2011 9:53:55 AM
4.056 5/26/2011 9:53:56 AM
4.055 5/26/2011 9:53:56 AM
0.34 FALSE 5/26/2011 9:53:57 AM
4.054 5/26/2011 9:53:57 AM
4.054 5/26/2011 9:53:57 AM
1.77 FALSE 5/26/2011 9:53:59 AM
4.055 5/26/2011 9:53:59 AM
4.054 5/26/2011 9:53:59 AM
2.48 FALSE 5/26/2011 9:54:01 AM
4.055 5/26/2011 9:54:01 AM
4.055 5/26/2011 9:54:01 AM
3.78 FALSE 5/26/2011 9:54:02 AM
4.056 5/26/2011 9:54:02 AM
4.057 5/26/2011 9:54:02 AM
6.1 FALSE 5/26/2011 9:54:04 AM
4.058 5/26/2011 9:54:04 AM

Hi, My data is in the above mentioned format(notepad). I have imported this notepad file to excel. I need this data converted into a particular format. For example, considering the first six lines the required format to be as follows:


Please help me with this as I have about 1500 files to be converted and each file has 1500 lines.

Thank you,

Mowlik Sridharan

NOTE: If it is difficult to explain over typing please let me know so that I can give you a call and figure it out.

I want to convert code below to excell formula , can anyone help me?

    Dim total As Double, i As Integer 
    total = 0 
    For i = 1 To 50 
        Cells(i, 1).Select 
        If Cells(i, 1).Value = 17 Then total = total + Cells(i, 11).Value 
        If Cells(i, 1).Value = 18 Then total = total + Cells(i, 11).Value 
        If Cells(i, 1).Value = 19 Then total = total + Cells(i, 11).Value 
    Next i 
    Cells(1, 12).Value = total / Range("K21").Value 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

conversion of notepad to excel format

Hi Every one,
I have downloaded a report from net which is a .Tab file. I was not able to convert it to excel file. Could anyone out there help me to convert it.

How do I take an ACT database file and convert it to an Excel file?

Hope this question makes sense.

I want to cut and paste text from notepad and paste it to excel, then I want to single out the persons name and the persons age. Each name and age is on its own line like this:

1. Jim from Texas age 53 Analyst
2. Mary from Massachusetts age 44 human resources

I have about 400 names and I want to extract the name and age into their own columns without having to manually type in every name and age into it's own cell.
Is there a function that removes all text but numbers from a text string, and secondly, is there a function that removes all text but the first word of each sentence ? I have a lot of work ahead of me and would like to do this ehem efficiently.

I'm working to convert political expenditure reports from PDF to Excel, and I've tried most if not all of the "free trial" PDF conversion software packages. Does anyone have recommendations about dependable software in this area?

Many thanks in advance -


I was trying to convert a lotus123 to excel and did something that all my
excel worksheets (.xls) now open in wordpad. What did I do?

How can I get all mt files back to my normal excel


When I convert a .txt document to excel, my columns are all formatted to
general, and hwne I change them to numbers, it adds a zero at the end of the
numbers in one of my columns. The number is a 13-16 digit long number and as
an example it show in the cell as: 512345E +15. How do I avoid the extra zero
at the end of my number?

Is anyone familiar enough with EasyLanguage to convert the following to

Period = 0;
Value = 0;
For count = 0 to 50 begin
Value = Value + Interest[count];
If Value > 100 and Period = 0 then begin
Period = count;

I'm not familiar with EasyLanguage and I'm not sure about the direct
translation. Thanks for the assist!

I need to convert work 4.0 files (windows 95) to Excell 2003 (windows XP)

Thank you for you help,


Anyone know how convert a PDF file to excel?

Hello all!

I need to perform a conversion on some data (lots of data), using the following formula, but on an Excel spreadsheet, and I have no idea how to convert it to Excel formula format:


My input (data I already know) is: X, Y, Z, Xn, Yn, Zn.
What I need to find out: L*, a*, b*

Source of the formulas.

Any help will be greatly appreciated.

Thanks in advance.

Hi All,

I don't know whether this is right forum to ask this question or not, but still i want to give it a try. I have a screenshot of emails in jpeg format is there any thirdparty software which can convert them into excel ? any kind of help is appreciated. Thanks in advance.

Little Master


This is my first thread.

We use Excel 2007 to keep track of global assets by their serial numbers (which are often barcoded).
We have a new product with a new barcode that scans the following

Item S/N: 54079
When we scan the Barcode onto Excel in TEXT format, it reads as: 02690600070000054079

If I try to scan the barcode onto Excel in Number format (or try to convert from Text to Number), it reads as: 2690600070000050000
**Notice it omitted the actual serial number digits of "54079"

Is there any way I can I can apply a formula in Excel to remove the numbers of "026906000700000"??

I would like to have the data in Excel consistent with the serial numbers that are printed on the items.

PS: I can scan these items onto Notepad, then extract them onto Excel through the External Data feature.
However, since we track and scan thousands of these, it would be much simpler to have it all done in Excel, rather than go back & forth from Notepad to Excel.

Any help is appreciated, we keep track of over 6,000 of these items.

Adan V.


I have a large spreadsheet in pdf format that I want to convert to Excel. I have tried several programmes that will extract the data (not the charts), and will dump it into a worksheet, however all formatting and formulas are gone.

It will take days to have to try & work out all the formula links. Does anyone know of a programme you can use to convert all the data from a pdf into Excel including most importantly the formulas?



I want to convert .pdf files to excel format. I want to do this with VBA code as I am not allowed to install a software in my office.

Can anyone please suggest the solution?


I am working on some automation and wanted to know whether it is possible to make webpage TO a excel sheet.

I am attaching a screen shot for the same. Everyday morning I used to log on to this intranet site and run the webquery to generate the report and later I export (Website has a link to convert the report to excel) to Excel report. I am trying this to automate as run a macro to get the report on to my computer and later I send the report to large team everyday morning.

I have data on disks that are in SuperCalc that I would like to convert to
Excel, but I don't know how to do that.

No luck finding an answer? You could always try Google.