Free Microsoft Excel 2013 Quick Reference

Convert notepad to excel Results

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.

Thanks

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

Thanks

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:

Pressure/MA1/MA2/Time
0.03/4.056/4.056/9:53:52AM
0.18/4.056/4.056/9:53:54AM

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.

Morning,

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.

Hi team,

Could someone please suggest how can i convert all the text which is not in format in a squential format.

Iam attaching an sample of it.

It would be an real help if someone does it for me.

Many Thanks in Advance.

Regards,
Shekar.

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!

Hi,

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.

Thanks

I have a text file which I would like to convert it into excel sheet using a macro. The issue is notepad file is too huge as it is a report of some software application. I am sending you a sample report. As I mentioned above I need to convert the text file into excel worksheet and then I have to sum up the "net Amt" and "VAT Amt" ... the issue is notepad report is of multiple pages and during conversion all the page breaks and columns heading get converted into excel sheet .. hence makes it difficult for me to calculate "Net Amt" and "VAT amt" in one go. I need a macro that will eliminate all the breaks (column headings,page numbers, company names and table heading) from excel sheet and sum up all the "Net Amt"and "VAT amt".. Pls assist.. Please help me with a macro code for the same.

Thanks in Advance..

Regards,
Shahcu

Hello All,

Iam just trying to format an raw data(which has morethan 40,000 rows) which is converted from notepad to excel.

The major problem the token number which is below the name and quantity i need to bring the number to left side of the row.

i think this has not given an clear picture so iam attaching an sample sheet i hope someone would help me.

Thanks & Regards,
Shekar goud.

Hi,
I need some help from experts.

We received several sets of data as some sort of Notepad format. I am unfamiliar with this sort of data. How can you convert this into the excel format? I'm not even sure what to call it. The data is sloping from upper left to lower right.

I am trying to convert data received from a call report to usable data. The report looks like this:

timeperiod Off Ans Dly Long

0:00 1 1 0:05 0:05 1:00 0 0 0:00 0:00 2:00 0 0 0:00 0:00

The Dly and Long columns are hold time dat in mm:ss. Excel reads the data as a time (for example, 0:05 above is 12:05:00 AM when you click on the cell. Is there a way to convert this to total seconds without having to copy the data into notepad, removing the colons, and then separating using Text to columns?

Hi,

Copied my needed data from a website into txt/notepad and it's in the following format:

Joe Smith
123 Main St.
City, State Zip

I want to get in Excel in the following format (5 columns 1 line)
First Last Address City State Zip

I know how to get to the import wizard but am lost on how to get this data converted to the desired format.

Appreciate your responses! Thanks

Hello,

I have imported a report from Notepad into Excel. There is a column that
has various times in it, which I brought in as text (since I didn't have any
other options). I now want to sort by time, and have the time be in
ascending order. How can I change the format of this to time, so that Excel
recognizes it as time, and sorts it correctly. Is there some kind of formula
I can use?

Thank you

Saul,

I've come in on this discussion a bit late, but I had a similar - possibly
related - problem (when importing csv data with dd/mm/yyyy dates) a while
back, and found that it's a known problem with Excel 2003.

Microsoft Knowledgebase article 911750 - "The format of the dates is
incorrect when you use a VBA macro to convert a CSV text file in Excel
2003" - discusses a hotfix that's available to fix it, and also a code
modification which you can use.

I decided to use the code modification, rather than the hotfix, since it
(the hotfix) is a bit old and there have been some security updates since
it's issue and I couldn't be bothered messing around finding out what
updates I would need to reapply.

My knowledge on VBA and associated matters is extremely limited, but
assuming you're using XL2003 I suspect that what may be happening is that
when you open your csv file with VBA the dates which still appear OK are
actually imported as text, and then when you save them to a csv they show
incorrectly. Pure conjecture, I know, but it may be worthwhile using the
code modification suggested by MS when importing the data, and then see if
the correct format is maintained when you resave it.

Another article - "Converting date formats when the date isn't a date!" -
from http://www.fontstuff.com/casebook/casebook02.htm, may throw some more
light on your problem.

Just a thought. Hope it helps. :-)

Regards,

John

----- Original Message -----
From: "brawlsadford" >
Newsgroups: microsoft.public.excel.misc
Sent: Wednesday, May 16, 2007 4:41 PM
Subject: date format changes when I save to CSV via a macro

Hi Dave,

thanks for your response - I appreciate the help on this one!

Whether I open the new CSV file in Notepad or Excel, the entry reads:
9/14/2006 0:00 (in Excel the cell format upon opening is "General" - note
the change in hour format too)

The same entry in the master CSV (in both Notepad and Excel) looks like
this:
14/09/2006 00:00:00 (in Excel the cell format upon opening is "Custom -
dd/mm/yyyy hh:mm" )

When the data is pasted across into the macro workbook, the U.K. formatting
is preserved. After saving as CSV (automatically via the macro), the
formatting in the macro Workbook (i.e. the xlsm file) is still U.K. - if I
then save to CSV manually, the formatting is still dd/mm/yyyy hh:mm

It's only in the macro-saved version that this transposition to mm/dd/yyyy
h:mm is present.

Am I missing something?

Thanks Again,

Saul

"Dave Peterson" wrote:

> How did you verify that the dates changed?
>
> Did you reopen the CSV file in Excel or in Notepad?
>
> If you used excel, try using Notepad.
>
> brawlsadford wrote:
> >
> > I'm using a macro to extract rows of data from a large, master CSV
> > file -
> > breaking it down into chunks and re-saving it as smaller CSV files.
> >
> > One of the columns in the master CSV file contains date and time data in
> > the
> > format "dd/mm/yyyy hh:mm"
> >
> > The macro pastes this data into the workbook fine, but when the macro
> > saves
> > the sheet:
> > ActiveWorkbook.SaveAs Filename:=ActiveSheet.Name & ".csv",
> > FileFormat:=xlCSV, CreateBackup:=False
> >
> > ... all the dates have been transposed into mm/dd/yyyy!
> >
> > This doesn't happen when I save the sheet manually (Office button/Save
> > As...
> > CSV)
> >
> > My region settings are all set to U.K. - what's going on?
> >
> > Thanks, in advance, for your help,
> >
> > Saul

Hi,

Have data in a notepad/txt file in the following format:
Joe Smith
123 Main St
Anytown, AA 07340

Want this in Excel in the following format (5 columns 1 line).

First Last Address City State Zip

I've done this before, but don't recall the specifics with deliminated file
and such and can't figure out so will let you pros guide me.

Thanks

--
Paul

Hi,

Have data in a notepad/txt file in the following format:
Joe Smith
123 Main St
Anytown, AA 07340

Want this in Excel in the following format (5 columns 1 line).

First Last Address City State Zip

I've done this before, but don't recall the specifics with deliminated file
and such and can't figure out so will let you pros guide me.

Thanks
--
Paul

thanks biff, I tried it both ways and got the same result. I recognize there
is a strong possibility of user error and being a newby to excel w/o knowing
the root of formula creation creates additional issues. appricate your
thoughts.

"Biff" wrote:

> It's all one formula and to be entered as a single line in a single cell.
>
> Either type it in manually or try copying and then pasting into a plain text
> editor like Notepad. Place the cursor at the beginning of each line and
> backspace so there are no spaces. Kind of hard to explain!
>
> Biff
>
> "ynot" <ynot@discussions.microsoft.com> wrote in message
> news:1A5EF338-AEE8-4118-AE2D-2EE859AA61C4@microsoft.com...
> >
> > thank you for your prompt response as I should have noted I'm a true
> > rookie
> > to excel, as I only had the 2.5 minute training and probaly should have
> > bosted to the dummies for excel..... all values in column "A" = X' Y"; if
> > I
> > try to paste formule to B2.... which it won't allow I see MID(text,
> > start_num,NUM_CHARS) which the paste place
> > =LEFT(A2,FIND("'",A2)-1)+MID(LEFT(A2,LEN(A2)-1), in A2 and >
> > FIND("'",A2)+1,255)/12 in A3..... did I choke something?
> >
> > AGAIN thank you for your supportand patience.....
> > "JE McGimpsey" wrote:
> >
> >> One way:
> >>
> >> If all your values have both feet and inches (e.g., 8 feet is 8' 0"):
> >>
> >> =LEFT(A2,FIND("'",A2)-1)+MID(LEFT(A2,LEN(A2)-1),
> >> FIND("'",A2)+1,255)/12
> >>
> >> will convert the measurement to decimal.
> >>
> >> In article <BDEFD4DB-A57B-4D53-9A17-FB92017E563D@microsoft.com>,
> >> "ynot" <ynot@discussions.microsoft.com> wrote:
> >>
> >> > I have a column of measurments ie. 33' 8 1/2" which I need to convert
> >> > to
> >> > numeric value to compute square footage. all I get as result is error.
> >> > A1 =
> >> > width, A2: A40 = unique measurments.... D2:D40 = length measurments....
> >> > I
> >> > need to convert (ft) & (in) to numeric value multiply A$ by D$ = X and
> >> > convert? I think excell can do this but I'm to green to figure out?
> >> > Any
> >> > help is greatly appreciated. Thank you..
> >>
>
>
>

I am using data from a lab experiment and the data from the software is saved in lists, like in notepad or something. I have 22 files, with 680+ rows and 5 columns. It would take forever to manually type up each spreadsheet. I believe there is a simpler way to handle this but for the life of me, I just can't find it. If anyone could offer a solution, it would be extremely appreciated!

I have a notepad with the below kind of content

TOX
STAFF_CODE

LIST_ID
CHEM_LIST_TYPE
L_CONTEXT
THRESHOLD_BASIS_CODE
STAFF_CODE

LIST_ID
CAS
CAS_SEQ

I want to place it in excel in 3 rows i.e., blank rows should be treated as row delimiter

I'm using Excel 2003 and trying to convert a file to a CSV file... when I
save it as a CSV file it drops the leading zeros on a column that is numbers
stored as text.

I've stored the numbers as text in Excel using three methods:
1 - they all start with a ' as in '00123 '00124
2 - under Format > Cells, I've selected Text
3 - under Data > Text to Columns I've selected the column data format as text.

When I save as CSV file and then reopen it using Excel, it drops my zeros. I
have also heard that I should change the file extension to .txt, but when I
do this, it just changes it to .txt.csv and the zeros are still dropped.

When I save the same CSV file as a notepad, the zeros are there, but when I
open the notepad file in Excel, the zeros are dropped.

Any suggestions??


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