Hello marsch000, if you want to have a Space in between you can do this: (example) =CONCAT(A5, " ", B5) Thats's asuming that you have John in Cell A5 and Smith in B5 in this example. this would result in (John Smith) because of the Space
This has been very helpful, but it was missing one vital step for me, once I finish concatenate, I want to delete the source columns, and since the formula is still there I can't just delete the columns. What I do is copy the new concatenate column and then in a new column I "Paste Special" and choose to paste the column as a value. This one I can delete the source columns.
It is helped for my work. Thanks
Great being able to specify a range. Frustrating how this never was originally in Excel given it is such an intuitive notion.
Many thanks for explanation
THANK YOU! I was browsing for other methods because the =concatenate(transpose method didn't work as my F9 key wouldn't work. This is so much eaier
Thank you very very much :)
Perfect. Thanks.
Thank's a lot
That is so greating video.
What if I want to leave a space in between?
Hello marsch000, if you want to have a Space in between you can do this:
(example)
=CONCAT(A5, " ", B5)
Thats's asuming that you have John in Cell A5 and Smith in B5 in this example.
this would result in (John Smith) because of the Space
How do we separate the concatenated values by a comma?
Very well explained, can you make more videos of other Microsoft office products.
This has been very helpful, but it was missing one vital step for me, once I finish concatenate, I want to delete the source columns, and since the formula is still there I can't just delete the columns. What I do is copy the new concatenate column and then in a new column I "Paste Special" and choose to paste the column as a value. This one I can delete the source columns.
u are very moza