LinkBack URL
About LinkBacks
Hi guys,
I have attached sample files. I want to concatenate two words, but I want an output in the same format of the text. Is there any way to do this? Any ideas?
Hi guys,
I have attached sample files. I want to concatenate two words, but I want an output in the same format of the text. Is there any way to do this? Any ideas?
Click * below if this answer helped
This is not possible without VBA. Would you like me to move your thread to the correct section?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes. Please move. thank you.
One way
Please Login or Register to view this content.
Thank you for that. how about if range? is that possible.
Is that possible to make a range for that? Like range of b5 to b100 and c5 to c100 concatenate and retain format.
Please Login or Register to view this content.
Hi it shows like this.
the *FREE OF CHARGE is not fully formatted.
Last edited by AliGW; 02-12-2018 at 05:16 AM. Reason: Unnecessary quotation removed.
a typo...
Please Login or Register to view this content.
Thank you so much. its working.Originally Posted by jindon
a typo...
Please Login or Register to view this content.
Maybe this (shamelessly plagiarised from the www):
CTRK K to run the macro...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I already added u reputation. I tried twice, it says something not possible. thanks.
Awarding reputation is entirely at your discretion, however the system will not allow you to award too much to one person without awarding it to others, too - it's to prevent misuse of the reputation system. Some of us are not bothered about reputation points - just saying "thank you" in your thread is enough.
Wow dynamic range and Its working. But i have 500+ rows to concatenate. is there any way to do it once.
Select them all... Is there any limitation to what you can select??
I just now tried selecting all.... thank you so much its working perfectly. I don't need to go thru VBA to edit the range.
You need VBA for a macro, and the workbook needs to be macro-enabled!
Thank you for the info.Awarding reputation is entirely at your discretion, however the system will not allow you to award too much to one person without awarding it to others, too - it's to prevent misuse of the reputation system. Some of us are not bothered about reputation points - just saying "thank you" in your thread is enough.
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks