Hi, we have the following sheet and want to combine B2:C13 in D2 with comma
for example 25000,3600,5014
we have more data approx till C160, help pls
we are using Excel 2010
Hi, we have the following sheet and want to combine B2:C13 in D2 with comma
for example 25000,3600,5014
we have more data approx till C160, help pls
we are using Excel 2010
Mau be Try
D2=IF(D1="",B2,D1&","&B2)
drag down
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi ,
The quickest way is :
Enter in cell F2 the formula :Formula:Please Login or Register to view this content.
In cell F3 , enter the formula :Formula:Please Login or Register to view this content.
Copy down as far as you want. Since Excel has a limit of 32,767 characters in a cell , there is a limit to how far you can go.
Note that though a cell can contain 32,767 characters , only the first 1024 will be displayed.
Narayan
Last edited by NARAYANK991; 11-05-2019 at 01:43 AM.
Thank you all, For B column data its working fine, you all have given a best way to do it, thanks for it but what about C column, we also need column C data in D2
help pls
Last edited by Ajay45822; 11-05-2019 at 01:57 AM.
May be try
=IF(D12="",B13,D12&","&B13&","&C13)
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
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.
Do share expected result
HI AliGW, read the Forum Rule #3, from next time we will search that forum also and if find that anyone from my partner have asked the question we will post the url here,
https://www.mrexcel.com/forum/excel-...ers-comma.html
Last edited by AliGW; 11-05-2019 at 02:24 AM. Reason: Please don't quote unnecessarily!
Your 'partner'? OK ...
Cross-posting in itself is NOT an offence: cross-posting without links is.
Administrative Note:
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.
Code for UDF
To paste the codePlease Login or Register to view this content.
Tab Developer -->Visual Basic
VB window opens
Insert --> Module
Paste the code
Close VB window
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Pl see post #11
Hi kvsrinivasamurthy Ji, thanks for your attention
In Sheet 11, column c data is not added
Final Result will be:
25000, 741, 3600, 7214, 5014, 60, 4608, 547, 9105, 7458, 4258 9516, 3214, 3514, 1246, 5, 1264777, 16547, 5248, 15410, 6194, 2001, 4376, 5014
Last edited by Ajay45822; 11-05-2019 at 02:43 AM. Reason: sentance is incomplete
Hi ,
In the first cell , say F1 , put in this formula :
Formula:Please Login or Register to view this content.
In F2 , enter this formula :
Formula:Please Login or Register to view this content.
Copy this down as far as your data extends.
Narayan
Change Range in formula
Range can be selected as required.
=JoinNumbers(B2:C130)
Last edited by kvsrinivasamurthy; 11-05-2019 at 04:03 AM.
Thanks NARAYANK991 Ji for the help
Thanks kvsrinivasamurthy Ji,
Problem solved, you helped me a lot
Many thanks to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks