Microsoft Office Forums - View Single Post - [Solved] Query related to Concatenate?

Thread: [Solved] Query related to Concatenate?

View Single Post

Old

02-18-2018, 12:30 PM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2013

LearnerExcel uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

Query related to Concatenate?

How can I do the following in Excel Worksheet?

If cell A1 is not equal to blank then it should concatenate A1 & B1 adding in between "-" (Result sahll be in C1) as shown in the image.
Else
It should remove "-".

=CONCATENATE(A1,"-",B1) 'It needs to be modified.

Attached Images

Concatenate Query.PNG (1.9 KB, 16 views)

Reply With Quote