removing a space from starting of the text

S

shikha

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
 
M

Myrna Larson

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).
 
Top