Find All Numbers and Text in a cell
 

I have a column of Text and numbers that are combined. Sometimes the
column is just numbers and other times it is Numbers and text. For
instance LDDC68, LDDC69..... M45, 46......458, 459. I want to add
the next number in the list. I think I can use isnumber for the ones
that are numbers but not letters. I am doing this through VBA. any
help will be appreciated.

Thanks,
Jay