Apr 26 2022 01:56 AM
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
Apr 26 2022 02:10 AM
SolutionApr 26 2022 02:30 AM
Apr 26 2022 04:08 AM
Apr 26 2022 02:10 AM
Solution=A3&","&B1&","&B3
You can try this formula which works in my sheet.