data alignment

This is a discussion on data alignment within the Excel Questions forums, part of the Question Forums category; Greetings!!
data is as in attached screenshot link at
but when pasted as text in excel it appears / pasted ...

Re: data alignment

Please note that even though you posted images, if you have any concern about the IP addresses being public, you should delete them and repost with sample IP's only. If you can't, just PM me and I'll do it for you.

Re: data alignment

If you can manually copy from the web site, and paste the HTML text into Sheet1, you would get this (the country flags are not showing in column D in the screenshot):

Excel 2007

A

B

C

D

E

F

G

H

1

Last update

IP address

Port

Country

Speed

Connection time

Type

Anonymity

2

8 secs

200.195.44.158

3128

Brazil

HTTPS

High +KA

3

8 secs

183.60.80.122

80

China

HTTP

High

4

8 secs

201.64.247.3

8080

Brazil

HTTP

None

5

8 secs

95.215.48.146

8080

Ukraine

HTTPS

High +KA

6

8 secs

2.133.92.246

80

Kazakhstan

HTTPS

High +KA

7

1m 9s

89.28.101.245

3128

Moldova, Republic of

HTTPS

High +KA

8

1m 9s

187.104.39.49

8080

Brazil

HTTPS

High +KA

9

1m 9s

58.215.75.170

80

China

HTTP

High +KA

10

2m 8s

125.160.35.14

8080

Indonesia

HTTP

None

11

2m 8s

173.45.108.250

3128

United States

HTTPS

High +KA

12

2m 8s

190.12.50.18

3128

Ecuador

HTTPS

High +KA

13

2m 8s

82.116.53.175

8080

Russian Federation

HTTPS

High +KA

14

Sheet1

After the macro in a new worksheet Results:

Excel 2007

A

B

C

D

E

F

G

H

1

Last update

IP address

Port

Country

Speed

Connection time

Type

Anonymity

2

8 secs

200.195.44.158

3128

Brazil

HTTPS

High +KA

3

8 secs

183.60.80.122

80

China

HTTP

High

4

8 secs

201.64.247.3

8080

Brazil

HTTP

None

5

8 secs

95.215.48.146

8080

Ukraine

HTTPS

High +KA

6

8 secs

2.133.92.246

80

Kazakhstan

HTTPS

High +KA

7

1m 9s

89.28.101.245

3128

Moldova, Republic of

HTTPS

High +KA

8

1m 9s

187.104.39.49

8080

Brazil

HTTPS

High +KA

9

1m 9s

58.215.75.170

80

China

HTTP

High +KA

10

2m 8s

125.160.35.14

8080

Indonesia

HTTP

None

11

2m 8s

173.45.108.250

3128

United States

HTTPS

High +KA

12

2m 8s

190.12.50.18

3128

Ecuador

HTTPS

High +KA

13

2m 8s

82.116.53.175

8080

Russian Federation

HTTPS

High +KA

14

Results

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.