Trim to separate numbers from alphanumeric strings

[VBisgreat]

Hi,

Does anyone know how to trim a column of data just to get the front number?
456abcv -->456
11ufg -->11
1190audk-->1190

Thanks a lot!
VBisgreat

[romperstomper]

In code or as a formula?

[nimrod]

Here is a Macro Solution... just Select the area you want to .."trim" and then run this macro.

Please Login or Register  to view this content.

[romperstomper]

Since the numbers are at the start, you can just use Val:

Please Login or Register  to view this content.

[nimrod]

HI romperstomper:
Wow , thanks ... I hadn't seen that one before . I'll be remembering that one