If cell contains text then ......

Giganews Newsgroups
Subject: If cell contains text then ......
Posted by:  1ceman (1ceman.27iism_1147131600.717@excelforum-nospam.com)
Date: Mon, 8 May 2006


Having a braindead morning here.

I have 3 columns a=number, b=customer, c=quantity.

Column B has various customer names.
In column D, I need a formula which says if b2 contains text of any
kind then show the text with (2) tagged on the end.
ie if collins is showing in b2 then d2 should show Collins(2)

Apologies for this, head all over

1ceman's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34213
View this thread:http://www.excelforum.com/showthread.php?threadid=540089