Cell separator
zbrihi
-
vdfinternet Posted messages 487 Status Member -
vdfinternet Posted messages 487 Status Member -
Hello,
I have a problem separating data into different cells. The data is in the form 1,256,1,132,0,125,-1,253 and I want to have 4 columns with 4 numbers having 3 decimal places. The problem is that I cannot separate them using the character length since it varies from line to line.
Thank you for your responses
Configuration: Windows 7 / Firefox 26.0
I have a problem separating data into different cells. The data is in the form 1,256,1,132,0,125,-1,253 and I want to have 4 columns with 4 numbers having 3 decimal places. The problem is that I cannot separate them using the character length since it varies from line to line.
Thank you for your responses
Configuration: Windows 7 / Firefox 26.0
9 answers
Hello.
I believe we need to examine the source of the problem: Why this strange display?
Who imported the data? You? A colleague? Your boss? You don't know?
It would actually be enough to better configure the original file, so that the separator is a semicolon instead of a comma, and you would have data like
1.256;1.132;0.125;-1.253
which would solve all your problems...
Best regards.
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
I believe we need to examine the source of the problem: Why this strange display?
Who imported the data? You? A colleague? Your boss? You don't know?
It would actually be enough to better configure the original file, so that the separator is a semicolon instead of a comma, and you would have data like
1.256;1.132;0.125;-1.253
which would solve all your problems...
Best regards.
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
I want to separate a list of data that contains only commas; every other comma is a decimal comma and the other is a separator.
I think you right-click on the cell / cell property / then you set the corresponding number format. Is that what you need?
I have set my numbers correctly, but I want to have 4 cells with one number in each cell instead of 4 in one.
If there is a separator operator, but I can't make it so that it replaces every other comma with a separator
I thought about writing an algorithm using the find and replace functions to replace every other comma with a period and then use the separator
but I'm struggling a bit since I'm not very familiar with the open functions.
I thought about writing an algorithm using the find and replace functions to replace every other comma with a period and then use the separator
but I'm struggling a bit since I'm not very familiar with the open functions.