SOLVED

Question related to FIND AND REPLACE

%3CLINGO-SUB%20id%3D%22lingo-sub-2401120%22%20slang%3D%22en-US%22%3EQuestion%20related%20to%20FIND%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401120%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EHow%20do%20I%20find%20and%20replace%20a%20set%20of%20texts%20to%20a%20specific%20text%3F%3C%2FP%3E%3CP%3EI%20am%20working%20on%20a%20set%20of%20data%2C%20and%20I%20want%20to%20focus%20on%20a%20group%20of%20personnel%2C%20regardless%20of%20their%20ranking.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EI%20have%20%22Engineer%22%2C%20%22Engineer%20Grade%202%22%2C%20%22Senior%20Engineer%22%2C%20%22Mechanical%20Engineer%22%2C%20%22Snr%20Engineer%20Grade%201%22%2C%20%22Snr%20Engineer%20Grade%202%22%20etc%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20word%20%22engineer%22%20can%20be%20found%20either%20front%2C%20mid%20or%20end%20of%20the%20designation.%3C%2FP%3E%3CP%3EAnd%20ultimately%2C%20I%20would%20like%20to%20replace%20all%20the%20above%20to%20just%20%22%3CSTRONG%3EENGINEER%3C%2FSTRONG%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20quick%20and%20fast%20way%20around%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20what%20should%20i%20do%20with%20the%20help%20of%20%3CSTRONG%3EFIND%20AND%20REPLACE%3C%2FSTRONG%3E%20command%20OR%20with%20the%20help%20of%20%3CSTRONG%3EFORMULA%3C%2FSTRONG%3E%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attached%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2401120%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401140%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20FIND%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20column%20B.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2BH%20to%20activate%20the%20Replace%20dialog.%3C%2FP%3E%0A%3CP%3EIn%20the%20'Find%20what'%20box%2C%20enter%26nbsp%3B%26nbsp%3B%20%3CSTRONG%3E*Engineer*%3C%2FSTRONG%3E%26nbsp%3B%26nbsp%3B%20(see%20remark%20below).%3C%2FP%3E%0A%3CP%3EIn%20the%20'Replace%20box'%2C%20enter%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CSTRONG%3EENGINEER%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EClick%20'Replace%20All'.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERemark%3A%20in%20your%20sample%20workbook%2C%20you%20have%20Enginner%20instead%20of%20Engineer%2C%20so%20you'd%20have%20to%20use%26nbsp%3B%20%3CSTRONG%3E*Enginner*%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401180%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20related%20to%20FIND%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401180%22%20slang%3D%22en-US%22%3EIt%20worked!%20Thank%20you%20you%20so%20much%20sir%3Asmiling_face_with_smiling_eyes%3A%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E
Regular Contributor

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 have "Engineer", "Engineer Grade 2", "Senior Engineer", "Mechanical Engineer", "Snr Engineer Grade 1", "Snr Engineer Grade 2" etc

 

The word "engineer" can be found either front, mid or end of the designation.

And ultimately, I would like to replace all the above to just "ENGINEER"

 

Is there a quick and fast way around this?

 

So, what should i do with the help of FIND AND REPLACE command OR with the help of FORMULA?

 

Please help..??

 

Here is a attached file

 

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Zan_Hanifee 

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