Extract string from apha numeric fields
Biff,
I think the person asking for a solution wants to have a formula that will
extract both 12 and Z from 12z, etc. Can that be done?
Rob
"T. Valko" wrote in message
...
A1 = 12z
B1 = 12
C1 formula:
=SUBSTITUTE(A1,B1,"")
--
Biff
Microsoft Excel MVP
"mmmbl" wrote in message
...
I have a column (named size) that has contains both numeric and unit of
measure. I have extracted the numbers into a field but how can i extract
the
unit of measure into another column? Example
ColA Col B Col C
12z = 12 z
12pk= 12 pk
1ct = 1 ct
Thank you!
|