Forum Discussion
leftnotracks
Jul 28, 2019Copper Contributor
Combine contents of two text cells with a condition
I'm preparing a spreadsheet for Data Merge in Indesign. InDesign does not support conditions. The data contains phone numbers and extensions, but not all records have an extension. For phone numbers ...
Wyn Hopkins
Jul 28, 2019MVP
Yep that looks pretty much right, I'd change the >0 to <> ""
=F2 & IF( G2 <> "", " ext."& G2, "" )
=F2 & IF( G2 <> "", " ext."& G2, "" )