Great being able to specify a range. Frustrating how this never was originally in Excel given it is such an intuitive notion.
@ratandart
2 жыл бұрын
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
@marsch000
3 жыл бұрын
What if I want to leave a space in between?
@benjo3355
3 жыл бұрын
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
@WorldlyMusi
3 жыл бұрын
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.
@ibrahimismayilov9489
3 жыл бұрын
Many thanks for explanation
@benjo3355
3 жыл бұрын
Thank you very very much :)
@wolfandchill9597
2 жыл бұрын
That is so greating video.
@walterjohnson8192
2 ай бұрын
How do we separate the concatenated values by a comma?
@constantinekontos2733
3 жыл бұрын
Perfect. Thanks.
@Abdullah-cd5sz
3 жыл бұрын
Very well explained, can you make more videos of other Microsoft office products.
Пікірлер: 14