Interesting Text to Columns Anomaly (hyphen moved from after to before text)

[RBusiness]

Hello all,

I'm having an interesting issue with text to columns. I am converting the following URL with a / delimiter, but the output for the last column is -17 instead of the expected 17- (hyphen is before instead of after number). My format is text, I've also tried general, and I've also trimmed and not trimmed the original data.

Does anyone know why this would happen? Thank you in advance for your time and insights.

https://www.website.com/pp/category-name/17-

 

[Fluff]

That's because Xl thinks it's a negative number & so converts it.
To stop that, on the 3rd page of the wizard, select the last column & then select "Text"

 

[RBusiness]

That's because Xl thinks it's a negative number & so converts it.
To stop that, on the 3rd page of the wizard, select the last column & then select "Text"

Thank you, this was the solution.

I noticed something that I hadn't prior. When using text to columns, each column must be defined individually. I never realized this before where I would simply select "text" and believed it was applying to everything. This is not the case, it must be done at the column level. Thank you again because this made me look deeper.

 

[Fluff]

You're welcome & thanks for the feedback.