rpaterick Posted December 16, 2010 Share Posted December 16, 2010 If address line 2 is blank, I just need it to return a name. If it has a value in the data, I need it to be blank. ex: John Smith <value> <would return a name here 123 E. Way Street Anywhere, WI 54729 Suzie Smith <no value> <would be blank 456 E. Way Street Apt. 32 <has an address 2 Anywhere, WI 54729 Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.