inserting a space in a number

[Guest]

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]

hi

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

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

-via135

 

[Guest]

thanks

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

 

[via135]

"start_number" & "number of characters to be replaced" respectively!!!

-via135

 

[Guest]

Can you cutom format as ##_############0

 

[shlomop]

I think you can do it by selecting

DATA
Text to columns
Fixed width

this will help only if its allways the 4th number in the cel