Insert a 'space' between data in a cell...?

Hey all,

Would some kind soul point me in the right direction to solve my query please?!

I'm trying to insert a 'space' after the second character/number in a cell.

I.e 123456 should become 12 3456

I have tried =LEFT(A1,2)&" " but this just deletes all data after the space. I've also tried =MID(A1,2)&" " but this makes excel very angry.....

Please help!

Many thanks in advance.

Ashley

Hi
supposing your strings always have the same length, try
=left(a1,2)&" "&right(a1,4)

Hi all,

My appolgies for the duplicate posting - I'm new to excel and I wasn't sure if this was a general topic question OR a programing question....

arthurb QUOTE: supposing your strings always have the same length, try
=left(a1,2)&" "&right(a1,4)

my strings are of different lengths... example: 123456, 124d, aa122223 etc

any more help would be appreciated

Thanks

Then try this
=left(a1,2)&" "&right(a1,len(a1)-2)

Spot on! THANK YOU

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save