I have column A with values such as


I want to generate URLs from these numbers like https://example.com/id/xxxx. I want the column values to be updated and the generated URL to not go in another column.
What I mean is that when I enter a number into column A like 34000 the cell contents get automatically updated and the URL text should be the text of the cell.

I had looked at this it did what I wanted in another column and I had to drag the end of a cell with the formula so that it would work for the others.

Your Answer

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