| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add up string or text together
Hi
You can use the formula below to concatentate the comments =CONCATENATE(Sheet2!A1;Sheet3!A1) BUT if the concatentated text is longer than the merged cells, then it won't show the rest of the text. I would rather use a formula like the one below to show all comments, leaving cells empty if no entry was made. Then you can have a little macro to hide empty rows in the comment area. Best regards, Per "Dumidu Roshan (Hotmail)" skrev i meddelelsen ... hi everyone I have a workbook with 12 sheets in them it got 11 sheets for 11 employees say Fred Kathy mark so on... every worksheet has row 30 to 33 to column A to U reserved for employee comments A30 to u30 is merged cell so is a31 to u31 and so on.. to type in long lines of comments main page adds up all the times they worked in the main page I want to display comments from all the employee sheets can you add text or string together like numbers? how do I do this? thanks dumi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text string to Numeric string | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Hybrid Mode
