View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pal Pal is offline
external usenet poster
 
Posts: 2
Default Single Space in PRN

Hi,

I've written a macro (Excel 2003) to reformat an input file. It's all
going well but the output must be in a space delimited format with only
a SINGLE space between the 2 columns. The problem is that Excel insists
on putting in 5 spaces.


Is there a way to trim the extra spaces down to 1?

Cheers,