???

[LISA]

I have a spread sheet, in one column is the address:
125 Wharf St Apt A

How can I move the Apt A to another column easily? I can't
just Data/Text to columns because the addresses are all
different lengths.

Any help would be appreciated.

 

[Anon]

I have a spread sheet, in one column is the address:
125 Wharf St Apt A

How can I move the Apt A to another column easily? I can't
just Data/Text to columns because the addresses are all
different lengths.

Any help would be appreciated.

You need to specify what defines the split position for ALL of the addresses
and then help can be given. For example, is the split always at the third
space? Unless you can define this for your data, noone can write a formula
or code for you.

One possible approach might be to sort the addresses into blocks so that you
can define the split for everything within that block.