Use the Left and If Functions to display the word DISCARD if the address is a PO Box, otherwise leave the cell blank.
I am referencing column D and this is what I got but I only get a blank cell no DISCARDS
=IF(LEFT(D2="PO Box",6),"discard","")
Use the Left and If Functions to display the word DISCARD if the address is a PO Box, otherwise leave the cell blank.
I am referencing column D and this is what I got but I only get a blank cell no DISCARDS
=IF(LEFT(D2="PO Box",6),"discard","")
Hi Squirt03,
Try below one:-
Formula:Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
=IF(LEFT(D2,6)="PO Box","discard","")
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
Hi Squirt03,
Welcome to the forum
Try this...
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Everyone!!! I will try to help when I can.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks