Hello All,
The objective is to look for a particular sequence in a sentence of every cell and if the sequence matches, then to pull that value.
For Eg.
I want to look for XXXX-YYYY, where and Y are all digits, may be same or different like 2341-3241. So whenever such sequence is found in a sentence, it must be able to pull out that sequence and paste it in another column.
if the sentence is as below:
Heater sequence 4543-2343 is to be rectified, then 4543-2343 is to be extracted out and copied into another cell, in same row.
Please help on this.
THank You
The objective is to look for a particular sequence in a sentence of every cell and if the sequence matches, then to pull that value.
For Eg.
I want to look for XXXX-YYYY, where and Y are all digits, may be same or different like 2341-3241. So whenever such sequence is found in a sentence, it must be able to pull out that sequence and paste it in another column.
if the sentence is as below:
Heater sequence 4543-2343 is to be rectified, then 4543-2343 is to be extracted out and copied into another cell, in same row.
Please help on this.
THank You