How do I add the same text to numerous existing cells

W

Wanda_pb

How do I add the same text to numerous existing cells without having to
repeatedly type the text? Ex. adding .gif to XXE1149J, XXE1130J...
 
W

Wanda_pb

Thank you, that was very helpful, but I guess I should have mentioned there
were "/" also in the text. When I did your suggestion, it deleted the "/"
and the text between them, but did add the .gif to the remaining text. I
want to keep all of the text (including the /'s) and add the .gif to the end.
 
J

Jon Peltier

Wanda -

Why don't you show us what the text in the cells looks like. Copy a few
cells and paste as text into a reply.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
W

Wanda_pb

Here's and example of what I'm trying to add .gif to:
/graphics/BC1456Q
/graphics/BC1462Q
/graphics/BC1470X
/graphics/BC1471X
/graphics/BC1475X


Here's an example of what happens when I entered =A1&".gif":

AF 1100 C.gif
 
W

Wanda_pb

I'm an idiot. I didn't put in the correct cell. It works just fine.
Thanks!!!!
 

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

Top