How to obtain values from other columns in excel ??

Hiii all,
Plllease helpp. what is the method to concatenate values from two columns??
I want to obtain the values from three different columns in excel and want to check if those values are concatenated and present exactly in the fourth coulmn .

For eg.If column 1 has-PT50
column2 has-456
and column3 has -abc

in column 4 must contain PT50456abc.Otherwise itmust be colored in red. can we use '&' for it.? Please find the code.Its showin error.

Please Login or Register  to view this content.

Help