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

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Microsoft Form
#Power Automate
#hyperlinks
#Excel
#clickable hyperlinks
#automatically convert