how to break out a new column from exising col.

Hi I have a column which has data like this

1234 A

where 1234 is the room and A is the bed.

I should like to have the A as its own col.

so we would have the ROOM BED
1234 A

not as now it is

ROOMBED

1234 A

We have to make this assumption

room is always 4 positions
and the bed is always one blank follwed by the A

there can be discrepancies to this.

if so does this mean we cannot do this breakout?

the room is always numbers and the bed always Alpha does this help us?