Putting numbers in lines in one cell

[farzadtb]

Hi all

I need to gather numbers from different columns of each lines into one cell ( for each line) in the following format, I am not succeeding with the engineering format and the counter 1.1,2.1 ,etc :


1.1,2.393e+00, 1.019e+01, 1.560e+00, 2.821e+00, -2.505e+00, 4.428e-01
2.1,2.393e+00, 1.019e+01, 1.560e+00, 2.821e+00, -2.505e+00, 4.428e-01

the 1.1, 2.1 is the progressive counter that the first number changes. then after comma immediately I have the first number, then comma then space and next numbers and repeated for the next ones

I also add an image for better clarification

 

[farzadtb]

Also, when I change the formatting to scientific on my file , I can not do as this example one

 

[chiron]

Data>Text To Columns>Delimited>Comma>Finish

Or am I getting your question wrong?

 

[farzadtb]

What I want to do is to collect the column into one column, not to divide them. Are you saying this?

 

[sadboy309]

You can learn function TextJoin() to make it.

Link video TextJoin():
https://www.youtube.com/watch?v=NejIt6JUDJE

 

[farzadtb]

Thank you very much.
It seems that I should do it twice. Since from the second comma I also have a space after that. I hope the command knows space plus comma

 

[sadboy309]

I see function alright.

 

[farzadtb]

Is concatenate an alternative ? cause I use Excel 2016 non English version and it does not have this command !!!

 

[Fluff]

TEXTJOIN is only available if you have Office(365)

 

[farzadtb]

So how do I do this ? what is the alternative solution ??
since concatenate does not imply the separator