inserting a space in a number
 

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

inserting a space in a number
 

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

inserting a space in a number
 

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

inserting a space in a number
 

"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

inserting a space in a number
 

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

"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

inserting a space in a number
 

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 cell


--
shlomop
------------------------------------------------------------------------
shlomop's Profile: http://www.excelforum.com/member.php...fo&userid=9734
View this thread: http://www.excelforum.com/showthread...hreadid=535297