I have a list of cells that contain both a 2 or 3 digit text string and a 1 or 2 digit number separated by ", ". I need to extract just the number from the cell. The number always appears on the right side so I was thinking something like
=Right(A5,1)
How would I change the "1" to something that acts until a space is the next character left?
Here is an example of the cell value
UK, 23
UL, 26
MIT, 3
Thank you in advance
=Right(A5,1)
How would I change the "1" to something that acts until a space is the next character left?
Here is an example of the cell value
UK, 23
UL, 26
MIT, 3
Thank you in advance