Is there a way to search for a specific word or letters within a cell and copy the contents of that cell to another location? For instance, I'm looking for cells within a spreadsheet and within one column that contain AE. An example of a cell with AE in it would be:
.ASSY, AE3010-32X224-7.6mm-422-120V
The amount of letters in front of AE or behind it can vary. I want to find all of the cells that contain AE and copy the contents to a column in another worksheet. Any ideas??
Thanks!
.ASSY, AE3010-32X224-7.6mm-422-120V
The amount of letters in front of AE or behind it can vary. I want to find all of the cells that contain AE and copy the contents to a column in another worksheet. Any ideas??
Thanks!