Extract Partial Data

[madsc1]

I have an Access DB where the user appended unit #'s to the end of the address, IE 600 Columbia place 604. Not all records have this. I need to select the records that have the unit #, remove the unit #, and place in a separate column. I am familiar with VB, but new to VBA. Any ideas?

[RuralGuy]

Will this be a continuing issue? how many records are you talking about?

[madsc1]

14000 records, and yes its ongoing. For some reason the do not want to change set up, but I need to extract the unit # for my purposes.

[RuralGuy]

When you use a computer to do this the rules need to be pretty hard and fast as you know. Will it *always* be the case that this is the only reason there are numbers at the end of the field and it will always be numbers and nothing else (like unit A)?

[madsc1]

It will always be only numbers, and will always be a unit or street number. If it is anything else, I can ignore it. I'm thinking 1 loop to move down the column. an inside loop using IsNumber on len(cell) the len(cell) - 1 etc if this makes any sense to you.

[madsc1]

I am talking about exporting DB to Excel to do this.

[RuralGuy]

It can be done in Access.