How to convert a URL into a hyperlink automatically

Excel can detect URLs and convert them into hyperlinks when you press the Enter key on that particular cell. When working with a large data set with thousands of rows you may not want to go to each cell and repeat this process. Enter the HYPERLINK function.

[teenytinytoons]

i was doing this manually and this just saved me a ton of time. omfg. ty!!

[varshasingh]

how to save the url ?? because deleting the url column will delete the hyperlinks