how do I remove spaces from cells that were pasted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you remove trailing spaces withour Trim function? 8
importing numbers into .csv file 1
Removing spaces from cells not possible? 4
text to numbers 1
Displaying zeros in cells 2
Greater Than Symbols and calculations 0
How do I remove a space infront of text in a cell? 7
How do I remove extra space when text wrapping? 2

Back
Top