ExcelBanter - concatenate formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - concatenate formula (https://www.excelbanter.com/excel-discussion-misc-queries/232641-concatenate-formula.html)

Tacklemom

concatenate formula

Hi there,

I am wondering how to include spaces in this formula. I am joining 2 cells
but want 2 blank spaces between the joined cells. Thanks
--
Donna

Luke M

concatenate formula

Something like this:
=A1&" "&B1
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Tacklemom" wrote:

Hi there,

I am wondering how to include spaces in this formula. I am joining 2 cells
but want 2 blank spaces between the joined cells. Thanks
--
Donna

Shane Devenshire[_2_]

concatenate formula

Hi,

And if you are using the longer version
=CONCATENATE(A1," ",B1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Tacklemom" wrote:

Hi there,

I am wondering how to include spaces in this formula. I am joining 2 cells
but want 2 blank spaces between the joined cells. Thanks
--
Donna

All times are GMT +1. The time now is 03:20 PM.