View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Childs[_3_] Tim Childs[_3_] is offline
external usenet poster
 
Posts: 7
Default Stripping Spaces from Right Hand Side

Hi

I have tables of data from a financial system where the non-numeric raw data
is filled with spaces when supplied to me. I am using a loop to test each
cell for these "filler spaces" on the right hand end of each cell and then
applying RTRIM to get the valid text.

Is there a shortcut alternative to using the looping - it seems quite slow

Thanks

Tim