Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining data from multiple cells into one cell with commas
I have several cells containing data that have a common denominator that I
want to combine in one single cell with commas to separate the data. I have tried the following formula (acquired from elsewhere on this blog): =SUBSTITUTE(IF($A$9="20090501182755",$E$9&",","")& IF($A$10="20090501182755",$E$10&",",""),",","",COU NTIF($A$9:$A$10,"=20090501182755")) However, instead of returning the data I want, it shows no data at all, not even an error, just a blank cell. Any suggestions? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining data from multiple cells into one cell with commas
I think it all comes down to your use of quotes around your A9 and A10
values. If those are real XL recognized numbers in A9 and A10, then simply remove the quotes from your formula, OR ... Make the values in A9 and A10 text values by adding a single quote to the beginning of those cells. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "lawandgrace" wrote in message ... I have several cells containing data that have a common denominator that I want to combine in one single cell with commas to separate the data. I have tried the following formula (acquired from elsewhere on this blog): =SUBSTITUTE(IF($A$9="20090501182755",$E$9&",","")& IF($A$10="20090501182755",$E$10&",",""),",","",COU NTIF($A$9:$A$10,"=20090501182755")) However, instead of returning the data I want, it shows no data at all, not even an error, just a blank cell. Any suggestions? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining multiple cells in column to relate to one cell in 1st co | Excel Discussion (Misc queries) | |||
Combining data from multiple cells into one cell. | Excel Worksheet Functions | |||
Most efficient formula/combining multiple data cell ranges/seperat | New Users to Excel | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) |