| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell contains text then ......
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...o&userid=34213 View this thread: http://www.excelforum.com/showthread...hreadid=540089 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
