Breaking a number/text cell into parts

Hello all,

I'm trying to break down a string of alphanumeric characters into something I can use.

For example:
----column a---------------column b
1---9391000ndw-------------wight
2---963103sstaffor-----------stafford
3---5696535ssnance---------nance

The breakdown I need for the example above would be
--column a------column b-----column c-------column d----------column e
1---939-----------1000---------nd------------w-----------------wight
2---963------------103----------s-------------staffor------------stafford
3---569------------653---------ss-------------nance-------------nance

Column A will always be three numbers, but the rest can be any amount of numbers or letters, and there are no spaces.

Column D is the first part of the surname (column e), so I really don't need it.

I'm wondering if there is a way to search Column A from the right and delete anything that corresponds to Column B (ie, remove the "w" in row 1, the "staffor" in row 2, and the "nance" in row 3)

I've found some ideas for breaking out Column A, since it's always three numbers, but the rest has me stymied.

Any help is appreciated.

Sorry for the formatting, it looked good until it posted.

You are saying the first is ALWAYS three numbers, so =LEFT(A1,3) gives you the first column, is the second column always a number as well? or can letters be involved there too?

what I see as the real problem here is the last 2 data items:
2---963103sstaffor-----------stafford
3---5696535ssnance---------nance

separating a needed single 's' or a needed double 's'...that could be a major problem..

especially as your 3rd column is inconsistent with the data...sometimes it's a whole name, sometimes its a single letter...will be very hard to create a single solution that solves for all this...