Hi,
If I have text in B1 (Apples)
And text in C1 (Bananas)
How do I write a formula in cell A1 that will combine the text of both so that it reads 'Apples Bananas' in cell A1?
Everything I can think of gives me errors.
Thanks,
Hi,
If I have text in B1 (Apples)
And text in C1 (Bananas)
How do I write a formula in cell A1 that will combine the text of both so that it reads 'Apples Bananas' in cell A1?
Everything I can think of gives me errors.
Thanks,
Last edited by Rick-O-Shay; 03-19-2014 at 06:37 PM.
Try this
=B1&" "&C1
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
maybe b1&" "&c1
Edit: If you have numbers instead of text, you may need to include the TEXT() function to truncate decimals or show dates correctly
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=B1&" "&C1 works great. Thank you!
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation *
Thank you for the feedback!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks