Change text in a Cell

  • Thread starter Thread starter seanA
  • Start date Start date
S

seanA

How do I search a whole column, and If the Cell Contains the partia
string "STILE". I would like to changewhole text in the cell to b
"DIFFERENT".

Thanks for your Help
 
1. Select the entire column you want to search.
2. From the Edit MenuBar, select Replace (or hit Ctrl-H)
3. In the Find What text box put *STILE*
4. In the Replace With box put DIFFERENT

The asterisks at the front and back allow you to replace the entir
word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Excel Typed text appears in wrong cell 0
Excel If a Cell Contains a Certain Text (From Another Table) 0
Last Modified By in a cell by user 3
VBA set thick borders around non empty cells in range 0
Excel 2013 Merge Data 2
Find and move cells with text 8
find wildcard text between {} cut, and paste in another cell 8

Back
Top