Combining Text Strings

[olga6542]

Here is what I would like to do
Company Type of Work Desired Output
XYZ Electrical XYZ - (Electrical)
ABC Plumbing ABC - (Plumbing)


Any idea how to do this?

[olga6542]

Here is the spreadsheet

[brytboy2]

just put XYZ in cell A2, in B2 put SPACE and put Electrical in cell C2. In cell D2 put the following formula =A2&B2&C2.

[icestationzbra]

=trim(a2&" - ("&b2&")")

[brytboy2]

Have attached my solution, please find and comment.

[AlanF51MS]

Try this, it doesn't require the space columns

=concatenate(a2, ," ", "- (", b2,")")

Combining Strings problem - No Spacing.xls

[brytboy2]

Hey here is a simpler one, Works fine too =TRIM(A2&" - ("&B2&")")