| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
separate cell values with formulas - can this be improved?
"T. Valko" wrote...
.... . . . but I was also thinking of replacing ","&F22 with ","&LEFT(F22,FIND(" ",F22)-1)&"," but I like your use of SUBSTITUTE. Thanks, but there should probably be another SUBSTITUTE call to guard against irregular spaces. FIND(","&DAY(ROW(INDEX($1:$65536,B22,1) :INDEX($1:$65536,D22,1)))&",", ","&SUBSTITUTE(SUBSTITUTE(F22," ",""),"=",",")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Separate values in cell by delimiter | Excel Discussion (Misc queries) | |||
| find a cell matching separate column and row values | Excel Worksheet Functions | |||
| Copy cell values across separate sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
