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)
Formula for adding four values together
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula for adding four values together
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
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
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Formula for adding four values together
Thank you Hans
That was very clear and easy to understand
I’m taking my first baby steps into the wonderful world of formulas
That was very clear and easy to understand
I’m taking my first baby steps into the wonderful world of formulas