2013 – Paste a url together with title (Display Text) in Quick Edit mode

I have several hundred urls I need to paste in to a Sharepoint list. I can paste the urls with no problem, but I need to paste in a Title too (or ‘Display Text’ to give the exact system name for the field). I like to be able to paste in the ‘Display Text’ at the same time as pasting the url. I’m working in Edit / Quick Edit mode, rather than the standard mode.

When in Edit mode, I can click in the url field and it will allow me to manually type in the Display Text, but that’ll take ages and cause me to lose the will to live.

Image of list item, showing the url column


I’ve found a couple of posts with proposed solutions, neither of which work for me.

Link 1 and Link 2. This third link also looked useful, it involves using a workflow. *New addition: Link 4 and Link 6. (No, there’s no Link 5).

Link 2 Results

The second of the links above looked especially promising. In Excel I pasted in the formula they’ve used:

=CONCATENATE(“”””,B2,””””,”, “,””””,,A2,””””)

Yet the result I get is a #NAME? error.

Here’s a screenshot of what I see in Excel. The formula looks ok to, Excel appears happy to accept it, yet gives a bad result.

Excel picture with Concatenate formula

Link 3 Results

The workflow failed to paste the values correctly; the display text contains both the url and the ‘Display Text’.

Picture of failed url, created by workflow

result of using the workflow option

Link 4 Results

THis post has two answers, Sergei’s accepted answer has since been deprecated by Microsoft (html no longer permitted in calculated columns). I tried out the second answer, by using a calculated column, but this only returned the value of the text field I’m using as a title for the url.

5. Ganesh’s suggestion

Thanks for posting Ganesh. I tried out this method, I’m using Excel. Please note the formula that created the url. As you see in the 2nd and 3rd pictures below, the value ‘I am the Title’ is posted to both fields, the url has not been pasted in.

enter image description here
enter image description here
enter image description here

Link 6 Results

(I don’t have the correct version of Access to be able to attempt this method by Daniel Šmon, but am posting for reference for others facing the same issue as me. Yes, I’m selfless I know I know…)