If I have sv14 in a cell, is there a formula I can use to copy the text characters into one column and the number into another? The number of text characters and number of numerical digits could vary. (however it is a limited list of text characters that would proceed the digits. It would always start with one of the following:
b
v
h
s
d
db
e
s
sv
sh
c
cv
ch
f
pb
pk
po
code
(yes "code" is one of the text strings)
Thank you in advance! Paul