Creates and import table(using excel) to the forum

[shinki]

Can anyone here teach me how to make table(from Excel) in forum like this?

RKG (PRE) NAME................ NAT .PTS .#
001 (001) StunnaLights........ GEO 6090 .39
002 (002) hotel............... CHN 5845 .32
003 (003) Meelis.............. EST 4460 .44
004 (004) leoneo.............. CHN 4060 .37
005 (005) In The Zone......... USA 4052 .44
006 (006) HenryMag............ POR 3822 .39
007 (007) Capriati Rules...... USA 3792 .39
008 (008) denijs.............. POL 3780 .38
009 (009) MH0861.............. USA 3608 .41
010 (010) Shuai.P............. CHN 3536 .39

its using the code,but must i enters the dot manually?or is it can be done using MS Excel?

[martindwilson]

i dont know why but decide how long your longest string will be including a reasonable amount of ......
in your example longest string is
007 (007) Capriati Rules USA 3792. 39 and you want say 6. seperating

the string will end up in this case as 43
put in A1 (note the^ where you are going to put the .....)
001 (001) StunnaLights^ GEO 6090. 39
then in b1
=SUBSTITUTE(A1,"^",REPT(".",44-LEN(A1)))

[shinki]

i dont know why but decide how long your longest string will be including a reasonable amount of ......
in your example longest string is
007 (007) Capriati Rules USA 3792. 39 and you want say 6. seperating

the string will end up in this case as 43
put in A1 (note the^ where you are going to put the .....)
001 (001) StunnaLights^ GEO 6090. 39
then in b1
=SUBSTITUTE(A1,"^",REPT(".",44-LEN(A1)))

sorry,i really dont get it..
can u give me an atttacment files of this?