Forum Discussion
Solved
Question related to FIND AND REPLACE
Hello Everyone, How do I find and replace a set of texts to a specific text? I am working on a set of data, and I want to focus on a group of personnel, regardless of their ranking. Example: I...
Select column B.
Press Ctrl+H to activate the Replace dialog.
In the 'Find what' box, enter *Engineer* (see remark below).
In the 'Replace box', enter ENGINEER
Click 'Replace All'.
Remark: in your sample workbook, you have Enginner instead of Engineer, so you'd have to use *Enginner*
Select column B.
Press Ctrl+H to activate the Replace dialog.
In the 'Find what' box, enter *Engineer* (see remark below).
In the 'Replace box', enter ENGINEER
Click 'Replace All'.
Remark: in your sample workbook, you have Enginner instead of Engineer, so you'd have to use *Enginner*
It worked! Thank you you so much sir😊😊