View Single Post
  #3   Report Post  
Wanda_pb
 
Posts: n/a
Default

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.

"Barb Reinhardt" wrote:

=A1&".gif"

"Wanda_pb" wrote in message
...
How do I add the same text to numerous existing cells without having to
repeatedly type the text? Ex. adding .gif to XXE1149J, XXE1130J...