Kombined cells

[Ahlsen]

Hi,

I have 3 cells that i want to combined into one cell with the data devided with comma.

Example.

Cell1 = 23059907

Cell2= 20220613

Cell3= 2130063000

The kombined cell should show:
23055907,20220613,2130063000

I tried to use the format =A3&B1&B3 but that dosent add the comma between the cell data.

Brg

Max Ahlsén

[#2 · Accepted solution]

@Ahlsen 

=A3&","&B1&","&B3

You can try this formula which works in my sheet.

[#3]

@Ahlsen 

As variant

=TEXTJOIN(",",1,A3,B1,B3)

[#4]

When i use this the following alert comes:
There´s a problem with this formula
*you type: =1+1, cell shows: 2
To get around this:
*you type '=1+1, cell shoes: =1+1

[#5]

@Ahlsen 

Sorry, I didn't catch.

You may check this

in attached file

[#6]

@Sergei Baklan 

Thanks, that solved my case!

[#7]

HI,

Yes, thanks it also worked in my sheet!

[#8]

@Ahlsen , you are welcome