Deleting after 9 numbers

[johncon]

I have data in a column that has numbers letters and characters in, all that I require is the first 9 numbers (these are always the first 9 characters), any idea how this can be achieved.

Many thanks
John

[royUK]

Do you want VBA for this?

[johncon]

VBA would be OK.

Forgot to add that the data will be in column A from A2 onwards.

Thanks

[royUK]

The easiest way would be to simply use a helper column. If column B is empty then use it, if not insert a column.

In B2 enter =LEFT(A1,9) and copy down. Copy the column & PasteSpecial values. Then delete Column A

[johncon]

Roy

Many thanks, this will work.

John

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save