Reverse Concatenate

[PritiK01]

I have a data in A1 cell which is 'SDABCD' and I need to seprate/split this data as 'SD' in one cell and 'ABCD' in another cell. I have searched through the internet but could not find a suitable function. Is there a way I can do can the desired result without using 'Text to Column' function ?

Cheers
Priti

 

[SteveO59L]

=left(a1,2)

=right(a1,4)

 

[PritiK01]

Thanks for that. It does work !

Cheers
Priti