Posting data on mrexcel.com

[RET79]

Hi.

I wonder if there is a better way for me to write tables on mrexcel.com so that it is clearer what I am asking for.

Would posting data such as:

={"File","Sheet","Range","Value";
1,"Sheet1","A1:A20",59994;2,"Sheet1","A4",437;
1,"Sheet1","A5:A10",1135;1,"Sheet1","B1:B10",5646;
2,"Sheet1","A3",645;1,"Sheet1","B5",23;
2,"Sheet1","B2",253;2,"Sheet1","B1:B10",5646;2,"Sheet1","B3",2;2,"Sheet1","B6",34;
1,"Sheet1","B1:B10",5646}

make any sense to anyone? How would I get this data back on an excel spreadsheet somewhere , so that it is easy to understand?

And how do you use HTML to create tables, is there some webpage somewhere that can help you do one?

RET79

[ This Message was edited by: RET79 on 2002-05-19 06:58 ]

[sen_edp]

Hello Ret79


You van ask Colo to send you the nice file
that converts excel to html , so you can post it on the web.

Send him a PM and I am sure he 'll not deny it.

Nice Helping you

[Aladin Akyurek]

I wonder if there is a better way for me to write tables on mrexcel.com so that it is clearer what I am asking for.

Would posting data such as:

={"File","Sheet","Range","Value";
1,"Sheet1","A1:A20",59994;
2,"Sheet1","A4",437;
1,"Sheet1","A5:A10",1135;
1,"Sheet1","B1:B10",5646;
2,"Sheet1","A3",645;
1,"Sheet1","B5",23;
2,"Sheet1","B2",253;
2,"Sheet1","B1:B10",5646;
2,"Sheet1","B3",2;
2,"Sheet1","B6",34;
1,"Sheet1","B1:B10",5646}

make any sense to anyone?

Yes, it makes sense to me. It's much easier than anything else to re-create the data.

How would I get this data back on an excel spreadsheet somewhere , so that it is easy to understand?

What I do is as follows:

Copy this bit.
Activate A1 in a clean worksheet.
Go to the Formula Bar, paste it there, and enter.
Activate A1 and select a large enough area
and hit control+shift+enter at the same
time. Copy the area that is filled up and do
an Edit|Paste Special >Values. Remove
columns and rows with error values.

I get then this to see:

Microsoft Excel - Book1______________Running: xl2000 : OS = Windows (32-bit) NT 5.00
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp
A15		=
	A	B	C	D
1	File	Sheet	Range	Value
2	1	Sheet1	A1:A20	59994
3	2	Sheet1	A4	437
4	1	Sheet1	A5:A10	1135
5	1	Sheet1	B1:B10	5646
6	2	Sheet1	A3	645
7	1	Sheet1	B5	23
8	2	Sheet1	B2	253
9	2	Sheet1	B1:B10	5646
10	2	Sheet1	B3	2
11	2	Sheet1	B6	34
12	1	Sheet1	B1:B10	5646
Sheet1

To see the formula in the cells just click on the cells hyperlink

The above image was automatically generated by [HtmlMaker V1.24]
If you want this code, click here and Colo will email the file to you.
This code was graciously allowed to be modified: by Ivan F Moala All credit to Colo


Aladin

PS. Edit your own post regarding the data by entering an enter after each ";" just I have done. That will make my post also better readable


[ This Message was edited by: Aladin Akyurek on 2002-05-19 06:13 ]

[ This Message was edited by: Aladin Akyurek on 2002-05-19 06:17 ]

[ This Message was edited by: aladin akyurek on 2002-05-19 06:49 ]

[RET79]

Thanks guys, that is fantastic!!

RET79

[RET79]

Actually, I have just downloaded the ASAP utilities (which I highly recommend) which has a convert Excel to HTML feature on it, so in future you may see some nice tables coming from me

RET79

[Aladin Akyurek]

On 2002-05-19 06:46, RET79 wrote:
Actually, I have just downloaded the ASAP utilities (which I highly recommend) which has a convert Excel to HTML feature on it, so in future you may see some nice tables coming from me

RET79

I saw your testing. I just pasted the data into a worksheet. It appears not to produce extraneous chars around the cell values. However, it creates on the board a huge empty space, which is a disadvantage.

RET, will you please edit the data in your original post regarding ={...}? Just enter an ENTER after each ";".

Aladin

[RET79]

On 2002-05-19 06:55, Aladin Akyurek wrote:
However, it creates on the board a huge empty space, which is a disadvantage.
Aladin

Yes, this is a shame, but have managed to reduce the empty space though it still exists. Not sure what you mean by extraneous characters though???

RET79

[ This Message was edited by: RET79 on 2002-05-19 07:06 ]

[Aladin Akyurek]

On 2002-05-19 07:01, RET79 wrote:

Yes, this is a shame, but have managed to reduce the empty space though it still exists. Not sure what you mean by extraneous characters though???

RET79

[ This Message was edited by: RET79 on 2002-05-19 07:06 ]

Web pages have often extra spaces and (I believe) char 160 around values. When I paste your testing from the other forum, all of the cells get a colored background, but no extra spaces etc. as it is the case when you copy and paste data from stock pages for example.

Thanks for editing. The thread looks much better now.

Aladin

[Nimrod]

This looks great .... thanks guys .