Post

Curtis Frye
@curtisfrye.com

For the morning UK and Europe crew: Not all data you import into Excel uses commas to separate values. In this week's Techsoc movie, I'll show you how to use the new IMPORTTEXT function to bring in external data stored as text into Excel regardless of the separator character. youtu.be/63hfQT3yPDo

youtu.beImport text data into Excel using a formulaThe new IMPORTTEXT function lets you connect to an external text file using a formula rather going through the Data Tab or using Power Query. It’s the ideal solution for bringing a small data set…

2 reposts10 likes