AwesomeSteph
Board Regular
- Joined
- Aug 18, 2017
- Messages
- 80
I have an excel list of over 5 thousand cells in a column. All in column A.
Each cell is unique with different information in a different order.
I need to extract from each of these cells the numbers proceeding "RE" in each cell. however they are not all in the same place in the cell some are the beginning some are at the end and some in the middle. is there an easy formula that I can apply to column B that will find all "RE"'s that have numbers after it and produce just those numbers?
thank you so much for any help with this!
Each cell is unique with different information in a different order.
I need to extract from each of these cells the numbers proceeding "RE" in each cell. however they are not all in the same place in the cell some are the beginning some are at the end and some in the middle. is there an easy formula that I can apply to column B that will find all "RE"'s that have numbers after it and produce just those numbers?
thank you so much for any help with this!