Insert a Space
Posted by Manu on April 04, 2001 6:58 AM
How can I insert a space within a cell e.g. how can I display A2A2A2 as A2A 2A2
All help is much appreciated
Thanks
Manu
Posted by Mark W. on April 04, 2001 7:12 AM
There are lots of ways...
...here's one:
=LEFT(A1,3)&" "&RIGHT(A1,3)
where A1 contains "A2A2A2".
Posted by Manu on April 04, 2001 9:49 AM
Re: There are lots of ways...
Thanx a lot Mark, that was indeed helpful
Regards
Manu
