Adding .jpg to end of existing text in every row

Question

I read previous posts on adding text to a cell and copying it to another column.

I need to copy all part numbers and add .jpg to the names in column "U" to column "V" then I will delete column "U"

How do I make the text show and not the formula?

I have 421 part numbers to match to jpg photos.

Also something is wrong as it is showing formula U1 in all rows not automatically changing formula for each row as it goes down.

I am definitely missing something out, have read old posts but cannot see what I am doing wrong.

Thanks

Answer 1

Hi Tattoo,

I am John, an Independent Advisor and a Microsoft user like you. I'm here to work with you on this issue.

Please type the formula below to cell V3

=U3&".jpg"

Then copy/drag down cell V3 to fill the rest of the column. You will notice the cell references change as well.

To retain the value without the formula, highlight all the cells that contain formula. Then press Ctrl + C to copy and right click > under Paste Options > choose the second icon (please see screenshot below)

I hope it worked out well for you.

Please mark this as resolved if as such. If not, please reply back to this forum and I'll be gladly to assist you further.

Regards,

John

Answer 2

Hi Tattoo,

Please choose Values under Paste.

I hope it worked out well for you. If not, please reply back to this forum.

Thank you and stay safe!
John

Answer 3

Please mark this as resolved if it helps you.

Thank you,

John

Answer 4

Hi

JVP is making this way too complicated.

Clean out Column V and then type in column the two entires shown below

In the cell under the two entires press Control-e. The name of this feature is flash fill.

Done.

Answer 5

Thanks Jim,

JPV did confuse me a little but I got it done after a couple of tries.

If I do it your way next time, can I delete column U as that is just a copy of column A to have it next to column V to make the changes.

Thank You.