Formula for adding four values together

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Formula for adding four values together

Post by ABabeNChrist »

I have little to no experience with using formulas; almost everything I use is VBA.
I have a workbook where I want to combine the values of 4 cells in to 1 and by adding a “,” to separate the first 2 from the last 2
My question is, is this the current formula
The values I am combining a Address,Street, State, and Zip

=CONCATENATE(B12,B9,", ",B13,B10)

User avatar
HansV
Administrator
Posts: 78488
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Formula for adding four values together

Post by HansV »

You can use =CONCATENATE(a,b,c,...) or =a&b&c&.... to concatenate strings. Keep in mind that Excel will not separate the parts, not even by a space, so you must provide spaces between the parts yourself.
For example, if A1 contains 60 and B1 contains Richardson Road, the result of =CONCATENATE(A1,B1) or of =A1&B1 is 60Richardson Road, without a space between 60 and Richardson. If you want 60 Richardson Road, with a space between 60 and Richardson, you must use =CONCATENATE(A1," ",B1) or =A1&" "&B1
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Formula for adding four values together

Post by ABabeNChrist »

Thank you Hans
That was very clear and easy to understand
I’m taking my first baby steps into the wonderful world of formulas :grin: