2

I have a Google Sheets that has about 200 columns. Each one is a name, and to each one, I want to append -banner.jpg. For example:

abcde
fghij
klmno

will all be updated to:

abcde-banner.jpg
fghij-banner.jpg
klmno-banner.jpg

Is there a way to batch process this?

3

Please try:

Find: (.+)
Replace with: $1-banner.jpg
Search: This sheet
Search using regular expressions
Replace all.

  • 1
    Awesome. I just had to highlight/select the range I wanted. Cheers for that. – Kenzo May 14 '14 at 14:39
  • 1
    The latter - I only wanted a certain range and I had multiple columns. I didn't say that in the question because I thought I could figure that part out. Thanks again...I'm glad I know that works now. – Kenzo May 14 '14 at 14:59
0

=ARRAYFORMULA(REGEXREPLACE(A:A, "(.+)", "$1-banner.jpg"))

0


=ARRAYFORMULA(IF(LEN(A:A), A:A&"-banner.jpg", ))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.