Hi,
How can I concatenate column A and B. But only if cell contains specific phrase otherwise column A should be copied to column C.
![]()
Column A Column B Column C SASSDDSd AYZ SASSDDSd SFSSFSSFD SDD SFSSFSSFD specific phrase AWE specific phrase AWE SAFSSFS AYZ SAFSSFS SFSFSF&WDS AWE SFSFSF&WDS specific phrase SDD specific phrase SDD
Bookmarks