removing a space from starting of the text

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

Guest

I have a number written in one of the cells before which there is a space . I
cannot do any calculation because of that space. How do i remove that space
from beginning of the text such that it gets converted to a number
 
Assuming these are numbers, so contain no other spaces, just use Edit/Replace
and replace the space character with "nothing" (leave the Replace With box
blank).
 
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

Excel Subtract text after the third space and before the fourth (from between spaces) 3
Vlookyp fails due to space at the end 2
I need to add spaces to the beginning of my texts which are numbers 1
text to column 1
Removing spaces at the end of numbers 5
How to remove space from a cell. 15
remove tail spaces 2
trim cells with space in betwen numbers in cell 2

Back
Top