LinkBack URL
About LinkBacks
So I have to delete "ham" in multiple cells
When I do this it deletes the 3 letters "ham" in southampton so it leaves soutpton
Any idea how to just delete the word in the cells where it is without affecting text in other cells please?
So I have to delete "ham" in multiple cells
When I do this it deletes the 3 letters "ham" in southampton so it leaves soutpton
Any idea how to just delete the word in the cells where it is without affecting text in other cells please?
Put spaces either side of it, perhaps: " ham "
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi Ali Thanks
I tried a couple of things
- spacehamspace (- space not spelled out) it says it cant find anything to replace
if i use " ham " ("spacehamspace" - space not spelled out) it also says it cant find anything to replace
also tried hamspace - no good either
Please attach some sample data.
Attachment 657280
thanks again
would you like the sheet as well?
It's the workbook I need - I can't test a picture. Instructions at the top of the page.
hope this upload worked
ok done thank you
I'm vary confused. Which 'ham' do you want to replace???
Oh, forget that!
OK - when you open the Find & Replace dialog, there's an option button - open it and tick the box that says "Match entire cell contents". Then you can type just ham and nothing else into the search box.
they are scattered through the sheet first one is B2 second one is c15 etc
also have to replace city
and utd
etc
See post #10.
never knew that was there - thanks very much Ali
it says I have to find some more people to give rep to before I can give any more to you
And I had forgotten until now!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
A kind thought, but it's not what I do it for.Originally Posted by dougkpga
I explored a couple of other useful threads and now it says I have to come back in 24 hours lol - so will do - thanks Ali
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks