Hi! I'm new to this board and I'm sure this is a very simple solution however I'm stuck right now.
I have a column that looks like the below however consistently changes in number of characters and letter. I need to be able to separate the numbers from the letters as they are the unit of measurement. I believe the mid or right function would work together however I just can't figure it out. Any help would be greatly appreciated. I would love to be able to isolate both the numbers and letters into their own cells.
Thanks so much!
<tbody>
</tbody>
I have a column that looks like the below however consistently changes in number of characters and letter. I need to be able to separate the numbers from the letters as they are the unit of measurement. I believe the mid or right function would work together however I just can't figure it out. Any help would be greatly appreciated. I would love to be able to isolate both the numbers and letters into their own cells.
Thanks so much!
2.5Z |
2.25Z |
2Z |
2Z |
57G |
2Z |
2Z |
2Z |
6UN |
2Z |
50UN |
50UN |
10L |
<tbody>
</tbody>