1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Automatically convert text addresses to hyperlinks from Microsoft Form entries

Hi everyone...

I have an excel that is automatically fed data from Microsoft Form responses (via Power Automate), which includes link to web addresses, however it just pastes as plain text.

Can I have these links automatically converted into clickable hyperlinks, without the use of a helper column? The Excel is embedded into a Sharepoint site, so don't want to have the Excel too 'wide' and would prefer to avoid adding unnecessary columns.

Any ideas?

submitted by /u/Clemery_76
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article