thanks

by the way could you explain the 1,3, in the formula

"via135" wrote:


hi

assuming that your number (obviously formatted as text) is in A1,in

A2: =replace(A1,1,3,982&" ")

-via135


Anthony Wrote:
hi

have 15 digit numbers downloaded off scanner but need to insert a
space
between 3rd and 4th digits.

3000 to do so how can i do it with function or formula

ie. 982123456789876 should be 982 123456789876

thanks


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=535297