Excel not consistent when pasting external data as it pertains to column separators

I do a lot of ETL work, and often use Excel as a tool to profile and manipulate data coming from a variety of sources during development and for prod support. When pasting data into Excel, you nev...

excel

HansVogelaar
Aug 07, 2023
Wooderson

See this post for a macro that you can run to reset the 'Text to Columns' settings.

If you store the macro in your personal macro workbook PERSONAL.XLSB, you can call it whenever you need. You can assign it to a Quick Access Toolbar button and/or custom keyboard shortcut for ease of use.

HansVogelaar

MVP

Aug 07, 2023

Wooderson

See this post for a macro that you can run to reset the 'Text to Columns' settings.

If you store the macro in your personal macro workbook PERSONAL.XLSB, you can call it whenever you need. You can assign it to a Quick Access Toolbar button and/or custom keyboard shortcut for ease of use.

Wooderson
Copper Contributor
Aug 07, 2023
Awesome, I can create a couple versions of that so I can quickly enable different delimiters. Thanks!

Forum Discussion

Excel not consistent when pasting external data as it pertains to column separators

Resources