Jun 07 2022 01:19 AM
COL1 | COL2 | COL3 | CONCAT RESULT |
B972 | 02 | DPP | ('B972','02','DPP'); |
Jun 07 2022 01:44 AM - edited Jun 07 2022 01:46 AM
This is the formula for using concat is this, Concat(col1,col2,col3), and
=CONCAT(A2,B2,C2)
if you want to add space between values:
=CONCAT(A2," ",B2," ",C2)
Jun 07 2022 07:09 AM
@Jihad Al-Jarady It's not working as expected
Jun 07 2022 11:11 AM
SolutionJun 07 2022 11:31 AM
Depending on how precise you need the result to be, you might simply use:
=ARRAYTOTEXT(A2:C2,1)
Jun 07 2022 11:09 PM
Jun 08 2022 01:52 PM
Jun 09 2022 09:02 PM
Jun 09 2022 09:40 PM
Jun 10 2022 04:04 AM
Jun 10 2022 05:37 AM
Jun 10 2022 05:42 AM
Jun 10 2022 06:14 AM
You are welcome
Jun 07 2022 11:11 AM
Solution