| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Excellent, thanks
"Peo Sjoblom" wrote: use =YourRange press enter, select the formula in the formula bar and press F9, copy. Note that named formulas can only hold I believe 255 characters -- Regards, Peo Sjoblom "nospaminlich" wrote in message ... Just a thought.... The array here is relatively quick and easy to type in. If you wanted to use the same principle for a much larger array is it possible to convert info in a range of say A2:C40 into a format that could be copied into the Define Name box thus allowing the info in those cells to be deleted? If so, how? Thanks a lot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Toggle multiple values in single cell | Excel Worksheet Functions | |||
| how to add two data validation lists to a single cell? | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
