How to make that if the word in cell have ab change whole word for ab
find ab replace whole word.JPG
The function find and replace find the word but replace only that part of word.
Please Login or Register to view this content.
How to make that if the word in cell have ab change whole word for ab
find ab replace whole word.JPG
The function find and replace find the word but replace only that part of word.
Please Login or Register to view this content.
Try chnge to
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by bulina2k; 01-30-2016 at 11:21 AM.
Nice one , jindon
Last edited by davesexcel; 01-30-2016 at 10:31 AM.
OOps, I didn't look at the picture... bit more complex than I thought...
Try
Please Login or Register to view this content.
The message you have entered is too short. Please lengthen your message to at least 10 characters.
Last edited by davesexcel; 01-30-2016 at 04:43 PM.
jindon thank you very much. Works great. You did far more than on the picture but actually this was exacly what i was looking for.
I think it was not for begginer, but i will analise it to get how it works.
Can i ask you just one more thing.
Can you make this code to put to the last column only the replaced texts?
only replaced.JPG
Grens
No one wants to work with picture, I normally do not post the code, so better upload a workbook.
Not tested.
Please Login or Register to view this content.
Thank you it's working great just puts the comma between the text.
I tried to make this code without commas but it's still to difficult for me.
Could you just make this end result without commas?
replace.JPG
Sorry for not adding excel file, from now on i will add it
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Grens
Just change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks