LinkBack URL
About LinkBacks
Hi All,
I have to concatenate as below....
A B C A
4% a d 4% a d
Thanks all.
Hi All,
I have to concatenate as below....
A B C A
4% a d 4% a d
Thanks all.
Hi, and welcome to the forum
Please clarify your request. I don't understand it. The best way to do this is upload an example workbook and manually add the result you expect to see.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
So what's the problem? =A2&B2&C2 etc. . .
Pete
Hi All,
The problem is I have P1 to P4 columns, I need to concatenate data from P1_95 to P4_95 as well as P1_90 to P4_90 into P1 to P4 columns.
The constraint is that if P1_95 and P1_90 are containing any alphabet same then P1_95 should be retained as the data from P1_90 to P4_90 contains small letters and data from P1_95 to P4_95 contains capital letters.
I have attached a sample file which contains Data sheet and expected results sheet as well. I am trying to get, plz help me. thanks a lot.
Regards,
Rajesh M S
In c13, wht is the MINIMUM value concatenated with a letter, when in the other rows, it is the MAXIMUM value that is concatenated with a letter?
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
Hi Glenn,
There is no minimum and maximum values. The only requirements is what i have posted earlier.
I don't really see how to do this by formulae. I have asked others, expert in VBA, to have a look at htis.
See attached.
Please Login or Register to view this content.
You should use arrays in such cases:
Please Login or Register to view this content.
Last edited by snb; 11-24-2015 at 11:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks