How do I Export Columns as text with specified number of spaces in between?

[Fucius]

Hi Guys,

How do I Export Columns as text with specified number of spaces in between?

ie: Column one (then 40 spaces literally) Column two (starting at space 41) Column Three (starting at space 120)

I tried doing this in word but I couldn't find any accurate way of placing custom # of spaces in between each column.

Any help would be greatly appreciated!

Thanks

 

[anandvarma]

try this

Excel Workbook
	A	B	C
1
Sheet2

 

[Fucius]

Thanks for your reply anandvarma. Do I paste the code on top of each column? When I save as a Unicode text file, it seems to put a tab in between columns. Is there a way for the tabs to be flush side by side with no tabs or spaces?