Text to columns does not work with multiple select

[jon]

Trying to parse a CV with 4178 rows including the header, I browse to Data > Text to Columns, however, unfortunately after I do a multiple selection and try to have the data parsed to columns, the option is disabled.

Is it possible to consider enabling this function for large data sets?

I use UCI Machine Learning Repository: Abalone Data Set, as a possible source of datasets maybe you can suggest others. I am working on a machine learning algorithm any specific technical advice would help.

3 points are required to enable me to upload files e.g. screenshots and samples to demonstrate the problem.

Is this a bug or would this be a request for enhancement?

[mariosv]

Text to columns applies for a single range in one column, not multiple selection available.

But you can do it, pasting as unformatted text with Paste special [Ctrl+Shift+V] Menu/Edit/Paste special:

Data:
M,0.455,0.365,0.095,0.514,0.2245,0.101,0.15,15
M,0.35,0.265,0.09,0.2255,0.0995,0.0485,0.07,7
F,0.53,0.42,0.135,0.677,0.2565,0.1415,0.21,9
M,0.44,0.365,0.125,0.516,0.2155,0.114,0.155,10

[karolus]

why did you not in first place →Insert→sheet from file....http://archive.ics.uci.edu/ml/machine-learning-databases/abalone/abalone.data with proper settings??