View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shekhar Thakurdesai Shekhar Thakurdesai is offline
external usenet poster
 
Posts: 1
Default Copying from excel to txt + formatting.

I have to copy an excel file into a txt file.
But when i copy paste columns(data) from excel and paste it in notepad
I get tab's between the two columns data.I need it to be a space.

eg.when i copy 2|3|4 (data in columns 2,3,4)
i get 2 3 4 (with tabs in between)
i need it to be 2 3 4.(with a single space in between numbers)

Could some one help me out with a fast way to do it.