Sarahsodapop
New Member
- Joined
- Jul 19, 2011
- Messages
- 17
Hello!
I'm stumped -- I need to extract certain identifying numbers from a cell with a LOT of text, plus other miscellaneous numbers & years... The numbers I need all start with 34, but then can vary from 6-14 numbers, might end in zeroes, and can be followed immediately by either a space or letter or punctuation. I would love to get them all extracted into individual cells, and add zeroes onto the end of some (to make each one consist of 14 numbers). I'm not sure of what the maximum # of instances of 34xxx may be within any given cell.
I've found what might be a similar UDF here: http://www.mrexcel.com/forum/excel-questions/900604-extracting-multiple-numbers-text-string.html, but I'm not skilled enough at them (super newbie) to customize to my situation. Here are some examples of the "Notes" cells, along with what my goal columns are (API 1, 2, 3, etc).
Any help is greatly appreciated, as always -- you guys (and/or gals) are the best!!
Thanks,
Sarah
I'm stumped -- I need to extract certain identifying numbers from a cell with a LOT of text, plus other miscellaneous numbers & years... The numbers I need all start with 34, but then can vary from 6-14 numbers, might end in zeroes, and can be followed immediately by either a space or letter or punctuation. I would love to get them all extracted into individual cells, and add zeroes onto the end of some (to make each one consist of 14 numbers). I'm not sure of what the maximum # of instances of 34xxx may be within any given cell.
I've found what might be a similar UDF here: http://www.mrexcel.com/forum/excel-questions/900604-extracting-multiple-numbers-text-string.html, but I'm not skilled enough at them (super newbie) to customize to my situation. Here are some examples of the "Notes" cells, along with what my goal columns are (API 1, 2, 3, etc).

Any help is greatly appreciated, as always -- you guys (and/or gals) are the best!!
Thanks,
Sarah