J
jasondebolt
I'm trying to extract a 15 digit number from a long text string within
cells.
Many of the cells in my spreadsheet have lots of text, with sometimes
200-300 words per cell. Each of these cells has one15 digit number
that I need to extract and separate from the text. This 15 digit
number will then be pasted into a different cell.
Normally, I would do a search for a 6 digit number that begins with 1
within a cell like this:
"This is my text 123456 hello everyone" --> text in cell A1
=MID(A1,FIND("1",A1,1),6) --> formula in cell A2
123456 --> result in cell A2
However, I'm looking for a 15 digit number that doesn't start or end
with the same numbers; it's a completely random number. There is
nothing before or after the numbers to reference, such as "order #" or
"# of days."I don't think there are any wildcard characters in excel
exclusivley for numbers. Anyone know how to create a formula for this?
Thanks,
Jason
cells.
Many of the cells in my spreadsheet have lots of text, with sometimes
200-300 words per cell. Each of these cells has one15 digit number
that I need to extract and separate from the text. This 15 digit
number will then be pasted into a different cell.
Normally, I would do a search for a 6 digit number that begins with 1
within a cell like this:
"This is my text 123456 hello everyone" --> text in cell A1
=MID(A1,FIND("1",A1,1),6) --> formula in cell A2
123456 --> result in cell A2
However, I'm looking for a 15 digit number that doesn't start or end
with the same numbers; it's a completely random number. There is
nothing before or after the numbers to reference, such as "order #" or
"# of days."I don't think there are any wildcard characters in excel
exclusivley for numbers. Anyone know how to create a formula for this?
Thanks,
Jason