Ask Your Question
1

Text to columns does not work with multiple select [closed]

asked 2015-10-21 09:13:41 +0100

jon gravatar image

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 http://archive.ics.uci.edu/ml/dataset... , 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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-26 22:14:11.501782

2 Answers

Sort by » oldest newest most voted
1

answered 2015-10-22 00:18:48 +0100

m.a.riosv gravatar image

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

image description

edit flag offensive delete link more
0

answered 2015-10-22 09:06:49 +0100

karolus gravatar image

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??

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2015-10-21 09:12:06 +0100

Seen: 674 times

Last updated: Oct 22 '15