Hi
I've got details in 4 different cells that i want to combine as one line of text in one cell.
I use the & function, but there is no spacing between the words. How can I format it so there is spacing.
Thanks
Hi
I've got details in 4 different cells that i want to combine as one line of text in one cell.
I use the & function, but there is no spacing between the words. How can I format it so there is spacing.
Thanks
Along lines of:
=A1&" "&B1&" "&C1&" "&D1
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks