View Single Post
  #1   Report Post  
GolfKing
 
Posts: n/a
Default how do I remove spaces from cells that were pasted

I am pasting numbers into a spreadsheet, however its treating them as text
because there is a space before the number. How do I remove the space so it
treats it as a number ? I have used the =trim() function and its not working.
Thanks for any help !