Adding a Space
Posted by Michael on December 19, 2001 1:07 PM
Hello! I've got a column of data in Column A. I need to add a space before the second to last character. The text are different sizes. Here's an example of what I need:
Current Needed
AB433414 AB4334 14
FD543 FD5 43
How would I accomplish this?
Thanks!
Posted by Juan Pablo G. on December 19, 2001 1:10 PM
=LEFT(A2,LEN(A2)-2)&" "&RIGHT(A2,2)
Juan Pablo G.
Posted by Mark W. on December 19, 2001 1:11 PM
=LEFT(A1,LEN(A1)-2)&" "&RIGHT(A1,2) (nt)
Posted by Aladin Akyurek on December 19, 2001 1:12 PM
=SUBSTITUTE(A1,RIGHT(A1,2)," "&RIGHT(A1,2))
Aladin
Posted by Juan Pablo G. on December 19, 2001 1:14 PM
Aladin, isn't this a little risky ? for example:
A121313
wouldn't be replaced with
A12 13 13
?
Juan Pablo G.
Posted by Aladin Akyurek on December 19, 2001 1:21 PM
Good point..
it can be taken care of making the formula longer...
Juan -- thanks pointing out that.
Aladin
======= Aladin, isn't this a little risky ? for example: A121313 wouldn't be replaced with A12 13 13
Posted by Aladin Akyurek on December 19, 2001 1:36 PM
Juan: An alternative that...
might please you too..
=REPLACE(A1,LEN(A1)-1,2," "&RIGHT(A1,2))
Aladin
======== it can be taken care of making the formula longer... Juan -- thanks pointing out that. Aladin ======= : Aladin, isn't this a little risky ? for example
Posted by Mark W. on December 19, 2001 1:46 PM
Bravo! (nt)
=REPLACE(A1,LEN(A1)-1,2," "&RIGHT(A1,2)) Aladin ======== : it can be taken care of making the formula longer... : Juan -- thanks pointing out that. : Aladin : =======
