move part of cell data

we have a spreadsheet of names, addresses and other info. we need to edit it by taking just the number part of the address and moving it to its own column. there are over 3000 entries and cutting and pasting is way too tedius. is there another more efficient way of doing this?

Originally Posted by VBA Noob

If you post a sample of the data then you've got a better chance of a reply

At the moment I can tell if it's all in the cell in the same column or across several columns

VBA Noob

thanks, its all in the same cell and the numeric part of the address needs its own column. so instead of double clicking into edit mode for each cell and cutting and pasting the numeric part from say column f to column d for 3000 entries we need to know how to do this more efficiently. thanks in advance

Insert a column immediatly to the right of your column of mixed addresses.
Select the address column.
Text to Columns in the Data menu will help you split it.