| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract information from the list
Assume the list starts in A2, in B2 =--LEFT(A2,FIND(" ",A2)-1) copy down WoW! It works like a charm. However I couldn't figure out why it works. I understand you use "FIND(" ",A2)-1" to locate the position of space. But why does it work to remove extra "0"? It seems to do with the 2 magic "minus". (I still figuring out the rest of your codes! I'll have another reply soon.) Best |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
| Can you extract URL values from a list of cells? | Excel Worksheet Functions | |||
| Extract each item in the list | Excel Worksheet Functions | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Threaded Mode
