MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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