Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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!

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!