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?

Please Login or Register  to view this content.

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?