There is a formula in Excel that changes normal text to how it would look in a URL. For example, from sci-fi movies @netflix to sci-fi+movies+%40netflix.
Asked
Active
Viewed 72 times
-1
jonrsharpe
- 115,751
- 26
- 228
- 437
jatin verma
- 177
- 1
- 3
- 16
-
Does this answer your question? [How can I URL encode a string in Excel VBA?](https://stackoverflow.com/questions/218181/how-can-i-url-encode-a-string-in-excel-vba) – jonrsharpe Aug 10 '20 at 08:41
-
1that one? https://support.microsoft.com/en-us/office/encodeurl-function-07c7fb90-7c60-4bff-8687-fac50fe33d0e ... if so, google is your friend – Argee Aug 10 '20 at 08:41
-
@Argee thanks... its ENCODEURL... tysm – jatin verma Aug 10 '20 at 08:48
-
@Argee add this answer – jatin verma Aug 10 '20 at 08:51
2 Answers
0
I don't think there is any formula that converts a normal text to URL format. but if you know what is the criteria for converting text to URL you can create a custom function
Farrukh Saeed
- 1
- 1
-
but if you need google search URL (no specific website) then 1 possible solution is to create a macro that searches the text in google and copy the searched result URL in excel sheet – Farrukh Saeed Aug 10 '20 at 08:49
-