Microsoft Office Forums - View Single Post - [Solved] If Formula

Thread: [Solved] If Formula

View Single Post

Old

10-10-2018, 04:13 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Put this in B2 and copy down...

=IF(A2="","Brown",IF(ISNUMBER(SEARCH("Brown",A2)), A2,A2&"; Brown"))

Reply With Quote