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

Hi,

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
------------------------------------------------------------------------
1ceman's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34213
View this thread:http://www.excelforum.com/showthread.php?threadid=540089

Replies