how to break out a new column from exising col.

[bilter]

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?

[OnErrorGoto0]

If there is always a space between the two then you can use Data-Text to columns, choosing Delimited and Space as the separator.

[MarvinP]

Hi bilter,

See if the attached solves your problem.