Excel sheets

New Contributor

Hi community, 

I have a simple problem but don't know how to solve it.  I have a list of numbers - a column some 1500 deep and with rows of 5 and I want to simply insert a comma between each integer in each cell - how do I do this please? 

Thanks...

3 Replies

@Andy_MalkAMalk23 

Perhaps you could illustrate on small sample? Where are integers, what is desired result.

@Sergei Baklan 

 

Eurom = ['37', '36', '10', '20', '11',
25 4 28 34 45
11 6 35 36 21
28 46 2 17 12
32 48 6 24 30
30 47 35 31 21
16 38 1 45 15
13 1 24 11 49

I need them formatted as in the first line, with apostrophe's and commas seperating them from each other.  This is so I can use data analysis on the Spyder IDE, but the integers form a long list some 1500 rows down, so cannot be done by hand.  

@Andy_MalkAMalk23 

Like this?

image.png

with

="'" & TEXTJOIN("', '",1,A1:E1) & "'"