Hi,

I can understand about a column of cells that contain text and numbers mixed
but having extracted the numbers what do you want to do with them, I don't
understand


I want to add the next number in the list

Please clarify

Mike
"jlclyde" wrote:

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