Hi,
i have a very long list of items, which names include their measures:
FB_127_52
FB_129_19
FI_12_25
FB_12_52
FC_131_43
FE_132_19
FE_137_25
FB_138_52
FB_139_103
assuming this list is in column A
i would like to have the first number in column B, and the second number in column C
if we take the first name as an example, i would have 127 in B1 and 52 in C1
i could go "MID" and "RIGHT", but because the number of chars is not consistent, that won't work.
any idea how to automatically extract these numbers?
Thanks!
Bookmarks