Transferring text into more text?

[nokkieny]

I have a list of numbers/letters and I want to make them URLs

like this:
ABC123
DEF345
ABC345
123453
ABCDED

I want to make the entire list into a url like such:
www.site.com/ABC123.jpg
www.site.com/DEF345.jpg
www.site.com/ABC345.jpg
www.site.com/123453.jpg
www.site.com/ABCDED.jpg

[Søren Larsen]

Assuming you list starts in A1 you could put this in B1 and copy down:

Please Login or Register  to view this content.

[nokkieny]

thanks that worked, i was missing the & signs

[Søren Larsen]

You're welcome! Remember to mark your thread as solved...