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
@Lupp: it seems the IDs are in one Column : edit by Karolus
Thanks!
Please clarify whether the “list” is text contained in a single cell or whether it is content of three adjacent cells in a row given here separated by spaces - or something else like each ID in its own row. (best case).
In addition a solution by formulae will be simpler if you can assure that the numeric part at the end is always 4 digits.
each ID is in its own cell, in one column
Hallo
1st step:
→search and replace: \d+ by '& with option regular Expression
2nd step:
→Data→Text in Columns… Delimiter [x]other '
choose Text instead Standard for second Column to pretend the leading zeros cutting off.
perfect thank you so much!