I have used concatenate to create this :
R 01 001 A 1 R01001A1 R 01 001 A 2 R01001A2

I want to do the same thing in reverse:
taking R01001A1 and seperate into the original 5 cells but on another sheet

Thanks