Merging two cells and separating data with symbol

[Natale]

Hi all!

I've a file (structure is always the same) with data that I need to merge and separate with "+".
More precisely, in "Tutor" sheet you find columns with "Tutor 1", "Tutor 2", etc.
For each tutor, for each day, there are two cells (both with/without text or only one of them).
I need that always (also if they're empty) the 2 cells (for each day) are merged and, if both cells contain text, data must be separated by "+").

In "Desidered" sheet you can find an example of what I ask.

Please, can someone help me?

Note 1: "Tutor 1, 2, etc" will be replaced by real name.
Note 2: AC and AD columns can be deleted.

[ByteMarks]

Something like this in the Worksheet code

Please Login or Register  to view this content.

[Natale]

Something like this in the Worksheet code

Please Login or Register  to view this content.

Thank you very much, ByteMarks!
It works perfectly! :D :D

[alansidman]

Please don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Natale]

Ho, ByteMarks!

Today I've tried your code in real file. It doesn't work because cells in row 4 contain real name, not "Tutor 1, 2, etc" (ad I wrote in first message).
I'm trying to modify it but I can't.
Suggestion, please?

[ByteMarks]

Sorry.I missed that.
Try deleting the columns first and then just checking for something in row 4

Please Login or Register  to view this content.

[Natale]

Hi, ByteMarks!
Don't worry, you've been precious again!
It works but I find another strange problem: if I copy the result of macro in a new file, cells are copied 2 by 2, not like a unique cell (I don't know if i'm clear).

[ByteMarks]

I'm not noticing anything unusual if I copy the results to a new file.