I hope someone can help.
The best way of describing my problem is this:
I want to be able to have a set of names replaced by one singular name, e.g.
hilton monkeys on top
Hilton jimmy on top
Hilton jimmy on top with bananas
Marriott jimmy on top
(ofcourse these are made up!). What I would like is to group the names to simply 'Hilton' and 'Marriott'. There must be a way of doing this, so I don't have to select all the separate cell numbers. Is there a simple way. I have tried using replace in Excel and that doesnt allow me to do it. Macros must do, but I'm trying to avoid having to write 5000 scripts selecting each particular cell. Is there any way of doing this?
Surely the 'replace' function should do it with some key character like replace hilton * with Hilton??? Thats all I want, but there doesnt appear to be that option. So anyone have any ideas?
would be very grateful to hear from you.