Put this formula in B1, assuming data in A1

=trim(A1)

Jalwwl

"wood1e" wrote:


Is there a way of deleting a space in a cell or several cells in
fact...in every cell I have a space at the begining of a number, and I
want to delelte that space...?


--
wood1e
------------------------------------------------------------------------
wood1e's Profile: http://www.excelforum.com/member.php...o&userid=12958
View this thread: http://www.excelforum.com/showthread...hreadid=573101