Filter ROWS based on the text-pattern at the start

[linko]

My MSOffice is Professional Plus 2010.

If I have text data in COL A as following:

-------------
[01199] SPARE_uC_FPGA_3
U20 K16 N2HET2[8] PASSIVE RM57L843
U40 AD5 IO_L61N_VREF_2 PASSIVE XC6SLX150T

[01200] SPARE_uC_FPGA_2
U20 L16 N2HET2[9] PASSIVE RM57L843
U40 AC5 IO_L61P_2 PASSIVE XC6SLX150T

[01201] SPARE_uC_FPGA_1
U20 M16 N2HET2[10] PASSIVE RM57L843
U40 AC6 IO_L53N_2 PASSIVE XC6SLX150T

[01202] SPARE_uC_CPLD_8
U20 N16 N2HET2[11] PASSIVE RM57L843
U30 13 IO_8 PASSIVE XA2C128

[01203] SPARE_uC_CPLD_7
U20 K4 N2HET2[15] PASSIVE RM57L843
U30 12 IO_7 PASSIVE XA2C128

[01204] SPARE_uC_CPLD_6
U20 L4 N2HET2[16] PASSIVE RM57L843
U30 11 IO_6 PASSIVE XA2C128

[01205] SPARE_uC_CPLD_5
U20 M4 N2HET2[17] PASSIVE RM57L843
U30 10 IO_5 PASSIVE XA2C128

-------------

I want to copy-paste only those ROWs into some other COL which have starting text-pattern as follows:

[xxxxx] <-- x's are numbers, so this is 5-digits number.

Also copy-paste the text after removing the above text-pattern in the ROW.

So for example:
[01205] SPARE_uC_CPLD_5

This will be copy-paste to a new COL as"
SPARE_uC_CPLD_5


OR alternatively if I can delete all ROWs which do not have above text-pattern at the start then I will also possibly get a list of ROWs with above text-pattern at the start.

[Olly]

You can use Advanced Filter, using pattern

Please Login or Register  to view this content.

See https://excel.solutions/advancedfilter20191209/ for a walkthrough.