Hi,
I've tried to search all the posts to see if anyone has run across this
before but couldn't find one. So here goes my question :-)
I'd like to be able to append some additional string (let's say "Hello ") to
the contents of a range of cells, regardless of what they were. For EX, if a
cell was "Linda", now it is "Hello Linda" etc.
What I've done in the past is to put a formular in the next cell (let's say
B1) that says ="Hello " & A1. That works but it's becoming quite time
consuming after a while.
I'd like to use just the "Replace" function and replace whatever in those
cells with "Hello " & Whatever. I tried to replace * with Hello* but that
didn't work. Excel ended up replacing all my cells with Hello* (the
asterisk, literally).
Please help!
Thanks!