VBA Code to optimize and clean data - Round II Merge columns

[JoaoVr]

Hey everyone,

I need to merge some columns in my excel database, so:

Please Login or Register  to view this content.

I'm using this basic formula to put all my data together.

The problem is not all rows have information, so when it doesn't have text it doesn't need to do anything, is there any solution?

[tom1977]

You want VBA code or formula?
Anyway below formula
=if(and(M2<>"";N2<>"";Y2<>"";AD2<>"");CONCATENATE("Activity: ";M2;"| Field: ";N2;"|Feedback: ";Y2;" | Other Obs.: ";AD2);"")

[JoaoVr]

You want VBA code or formula?
Anyway below formula
=if(and(M2<>"";N2<>"";Y2<>"";AD2<>"");CONCATENATE("Activity: ";M2;"| Field: ";N2;"|Feedback: ";Y2;" | Other Obs.: ";AD2);"")

I tried that as also, but there is a problem, M2 can be empty but not N2 (Just the activity field is empty and there is something on the Feedback field)

VBS would be better, my Office is in portuguese and I need to translate formulas, and VBA no =)

[JoaoVr]

Please Login or Register  to view this content.

Found it =)

SE = IF
E = AND
CONCATENAR = CONCATENATE