Revision history [back]

How do I separate letters and numbers into separate columns?

I have a list of device IDs starting with several letters and ending in several numbers, (see below) I would like to separate them so that I have the letters in one column and the numbers in the next column. Thanks for help in advance!

FAPSCC2013 CPDF1099 FAPSC1482 CPFQ0999

Thanks!

 2 None karolus 4024 ●15 ●39

How do I separate letters and numbers into separate columns?

I have a list of device IDs starting with several letters and ending in several numbers, (see below) I would like to separate them so that I have the letters in one column and the numbers in the next column. Thanks for help in advance!

FAPSCC2013
CPDF1099
FAPSC1482
CPFQ0999CPFQ0999


@Lupp: it seems the IDs are in one Column : edit by Karolus

Thanks!