6

In Google Spreadsheets it is possible to show an image in a cell using the formula =image('http://www.example.com/path/to/image.ext', 3) (where 3 means to use the images' original size).

I would like to include some text in the same cell as the image. I have tried to use concat but that results in #ERROR.

=concat(image(URL,MODE), 'string')

In the same cell, how do I combine an image and text at the same time?

2
  • 1
    I'm afraid you can't. concatenating an image and a string does not make much sense. – Vidar S. Ramdal Apr 21 '15 at 12:15
  • 1
    So there is no way to show both an image and text in a single cell? Post as an answer and I'll accept. – Richard Parnaby-King Apr 21 '15 at 13:50
6

There's no way, that I am aware of, to combine an image and some text in the same cell using the image function.

The concat method concatenates strings, only.

The only "workaround" I can think of, is inserting the image using Insert → Image, and positioning the image next to a text cell. But this is obviously not a perfect solution in any way.

0

It works if you insert the image using the over the cell option. You then have to resize and position the image so that it fits in the cell.

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.