Forum Discussion

Vaterraz's avatar
Vaterraz
Copper Contributor
Jun 11, 2021
Solved

Issues with Text to Column

Hello All,   The issue I am having is figuring out which setting I need to change in order to prevent the following scenario from happening. Please keep in mind this report has approx 18K rows and ...
BI & Data Analysis
excel
Formulas and Functions
training
  • HansVogelaar's avatar
    HansVogelaar
    Jun 11, 2021

    Vaterraz 

    Does it make a difference if you tick the check box 'Treat consecutive delimiters as one'?

     

HansVogelaar's avatar
HansVogelaar
MVP
Jun 11, 2021

Vaterraz 

Does it make a difference if you tick the check box 'Treat consecutive delimiters as one'?

 

Vaterraz's avatar
Vaterraz
Copper Contributor
Jun 11, 2021
You are awesome, that worked!! I can't believe I kept overlooking this box.
Thank You

Resources