Hello everyone. I am struggling a bit trying to pull some information out of a cell. I have these strings:
³ Sub-Cohort (SUBCOHORT)................................................................NONE ³
³ Embedded Value Group (EVGROUP).....................................................DEFAULT ³
³ Policy Count (COUNT).................................................................1.000 ³
With each string located in a single cell. (ie A1 has the entire first line, A2 has the entire 2nd, etc.)
My goal is to pull information from these strings and put them in a more user friendly format in excel.
In B1:B3 I want: and in C1:C3 I want
Sub-Cohort (SUBCOHORT) None
Embedded Value Group (EVGROUP) Default
Policy Count (COUNT) 1.000
I figured out how to extract the information I needed in B1:B3.
But I am struggling figuring out how to pull out the 1.000 for C3. I was wondering if there is a way to use the mid function from right to left. For example, I would start from the right, go left until I hit the first 0 which would be my start, then tell excel to continue to the left until it hits ".." (it can't be until "." because there is a . in 1.000). Is this possible? I hope my question makes sense.
Bookmarks