Separate Columns using Print #

[priyanka_mehta]

Hi all,

 

I m using Print # Statement for sending my output to .xls

Suppose i have one text as "a" and another as "b"

 

How can i get these strings in separate COLUMNS in excel file.

 

I tried using Tab(A1)/Tab(B1) and stuff but it it is separating the rows instead of columns.

 

Please Help!!

 

Thanks and Regards,

Priyanka

[Lee Mac]

I'm not sure if this is the correct advice, but usually one would separate data with commas when writing to an Excel file to signify separate columns.

[JONTHEPOPE]

hi lee lets be friends

[Lee Mac]

hi lee lets be friends

 

Haha, random!, and Merry Christmas to you Pope Jon, everyone on here are friends.

[BIGAL]

You can write a line also to a file just have a space between the "a" and "b" in excel open file it will ask for the delimeter character and a space is ok.

 

(strcat a chr(32) b)

[Lee Mac]

Thanks Al, didn't know that - I thought only commas can be used.