Quotation Marks around a [Field] when used as a URL/URL+Ticket# opens up Ticketing Tool Search Page

[Anonymous]

Question	Hello All, I am using Power Query Editor to check over the data and add a Custom Column that is going to be Type:WebURL. It will be used to open a Ticketing Tool Search Page and insert the ticket number. Thank you for your help as always. E M
Action	Add Custom Column
Formula used	"company.website/forms/xxxxxxx = "& [ticket_number] and "company.website/forms/xxxxxxx = "&"" [ticket_number]""
Display showed in PowerQ	company.website/forms/xxxx = TICKET0000311
Requesting your kind help on	How can you add " " to the ticket number on the Power Query Formula? The Ticketing tool needs to have the [ticket_number] between "quotes"
Result expected	company.website/forms/xxxx = "TICKET000031"

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Have you tried the following:

"company.website/forms/xxxxxxx = " & """" & [ticket_number] & """"

Pete

[Anonymous]

Pete, first Thank you! I tried many ways to add more and take away the "" marks ... but 

this was my last try

& "" &"[ticket_number]"&""