"start_number" & "number of characters to be replaced" respectively!!!
-via135
Anthony Wrote:
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
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=535297