LinkBack URL
About LinkBacks
Hi,
How can I let cell F5 for example contain both the texts or contents of cells A1 and B1? Is there a function that can do that purpose?
Looking forward to hearing from you.
Alya.
Hi,
How can I let cell F5 for example contain both the texts or contents of cells A1 and B1? Is there a function that can do that purpose?
Looking forward to hearing from you.
Alya.
Last edited by alyaahmed; 09-11-2013 at 12:13 PM.
=A1&B1
or
=CONCATENATE(A1,B1)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks a lot, NBVC.
How can I also separate the contents by a dash or a slash or a &?
Thanks.
Alya
You can this:
=A1&"-"&B1
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
Thank you so much, Alkey. Grateful to this website.
Alya
You're Welcome and please mark thread as "Solved" if your issue has been resolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks