Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing the directional out of addresses using nested IF .
I have addresses that have intermittant directional
charactors i.e. N street or S street or NW street. I used this combination of functions to conditionally parse the information but my logic is flawed somewhere. Any help would be appreciated. The fuctions I used were IF() Left() Find() =IF("S"=LEFT(E21,FIND("S ",E21,1)),"S",IF("N"=LEFT(E21,FIND ("N ",E21,1)),"N"," ")) Cell E21 has the following address N Avenue 235. The result of the function is #VALUE! The preceeding cell has S Avenue 67 and the return value was S. The first part of the formula seems to work but the nested if statments do not. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking two cells that are bi-directional | Excel Discussion (Misc queries) | |||
How do I set up a Speed and directional graph | Charts and Charting in Excel | |||
can you do a bi-directional link in excel | Excel Discussion (Misc queries) | |||
Bi-Directional Cell Linking | Excel Programming | |||
Bi-Directional Cell Linking | Excel Programming |