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

Thread: [Solved] Query related to Concatenate?

View Single Post

Old

02-18-2018, 02:59 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

One way...

=A1&IF(A1<>"","-","")&B1

or

=IF(A1<>"",A1&"-"&B1,B1)

Reply With Quote