excel function that does the same as "&" in vba?

[IanJG]

Is there a function or a way to add bits together like you can by using "&" in vba?
without having to go into VBA

 

[Rick Rothstein]

Is there a function or a way to add bits together like you can by using "&" in vba?
without having to go into VBA

It would help if you showed us an actual before and after example of what you are trying to do. With that said, the "&" works in worksheet formulas the same as it does in VBA. For example...

A1: "Hello"
B1: "There"
C1: =A1&" "&B1

 

[IanJG]

Thanks, should have tried that.lol I am making a complex workbook for a chemist. I have used a lot of Vba, but just want use a set of if statement to convert units for labels than add the name & Quantity & unit. thanks for the quick response. might allow me to get a few extra hours sleep tonight. thanks