View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Replacing multiple instances of character

On Mon, 21 Dec 2009 04:35:01 -0800, Colin Foster
wrote:

Ron, can't do the fixed width as there are different spaces used, so the
columns don't align


Ah, I thought when you wrote:

has been typed in a single
column using the Spacebar to line up the 4 columns of data



you meant there had been spaces inserted so the columns WOULD align.
--ron