Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merging data to a single cell
I work for a membership organisation and wish to produce membership cards detailing areas of qualification in list format. The card software is used by dragging and dropping field headers from an excel spreadsheet. Originally we planned to list the areas of qualification vertically but found that most members do not have all the qualifications and this would result in blank spaces. The ideal solution would be to merge all the quals into a single cell that would list them vertically on seperate rows...I have been told this is not possible....??? The second solution is to simply list the data using CONCATENATE...unfortunately, in doing so we are left with double spaces where data is missing. With up to 24 different areas of qualification we could have big spaces between data on the card. Wondered if anyone knows of a way to resolve these problems????? CHEERS..... Robbie -- robbiemc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
how to add two data validation lists to a single cell? | Excel Worksheet Functions |