| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to combine cells with shortest equation
So I have this equation that looks like
=C1&" "&C2&" "&C3&" "&C4&" "&C5 I was thinking maybe I could reduce the equation to just show the first and last cell like =C1:C2 but that doesn't work and even if it did i need the space between the two cells. and help are creating a reduced equation that uses the first and last cells and has a space would be greatly appreciated. thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use a cells from one worksheet in the equation of another | Excel Discussion (Misc queries) | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| Have problem in Manipulating Workbook Object and make macro shortest as possible | Excel Worksheet Functions | |||
| =IF(AND) equation pulls through N/A cells | Excel Discussion (Misc queries) | |||
| How to obtain the shortest range that encloses all the non empty cells? | Excel Programming | |||
Threaded Mode
