INSERT url in front of a cell

[Allgermanparts]

Hi All,
I have to add a url but don't want it to act as a link in front of a part number in a cell
so
http://allgermanservice.co.uk/Lemforder images/

10726 01

WOULD READ IN A SINGLE CELL

http://allgermanservice.co.uk/Lemforder images/10726 01

How to do please.

[pangam_s@yahoo.com]

Have you tried this.... in Formatting "Wrap" that cell or user "Shrink to fit" and read url in task bar.

Regards,
Suhas

[bmouse]

Could you post a sample file please?

[Allgermanparts]

OK guys thanks for answering. I can post the file but what I need to do is the following. In a column I have an sku in each cell. I am uploading to ebay and need to tell ebay where the image is located. so if my cell contains SKU 12345 01 then I need to add the text only of e.g http://allgermanservice.co.uk/Lemforder images/
the cell would read

http://allgermanservice.co.uk/Lemforder images/12345 01 and the same in all cells in the column.

[Allgermanparts]

Please ignore the url keeps showing a hyperlink. It needs just to be text

[bmouse]

So, you need to combine 2 cell values? Write down the 1st part in a cell then try something like =A1&A2

If you need to add a space or something, write =A1&" "&A2

[Allgermanparts]

Thanks for the reply. For some reason when I use the formula it just shows the formula text in the cell rather than doing the formula..

[bmouse]

I can assure the formula is correct, at least for Excel 2010

[Allgermanparts]

All good thanks very much

[erjfly2013]

This work almost exactly as I wanted it to for a similar use. The only thing excel doesn't seem to be doing automatically is turning the new hyperlink into a....hyperlink. It displays as black text but doesn't recognize as a hyperlink. Is this because the URL is http://##### and doesn't contain any www. or .com? Can I format the column to turn everything into a hyperlink?

[erjfly2013]

Got it:
=hyperlink(A1&B1)

This will combine two cells, and turn it into a hyperlink. Nice trick!