Posted to microsoft.public.excel.programming

ppeer

external usenet poster

Posts: 25

delete cell if part of cell contains

For a worksheet I would like to check the cells if they contain the
word "text".
Within a cell this word is always combined e.g.: text 06735
When the cell contains "text" I would like to clean the whole cell, so
text including e.g: 06735.
Result: a blank cell.

Please, can somebody help me out?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete part of cell value	Sinner	Excel Programming	2	May 26th 08 10:39 PM
Delete part of a cell	Francis	Excel Worksheet Functions	5	February 1st 08 07:58 PM
Delete Part of Cell?	Odysseus[_5_]	Excel Programming	5	June 30th 05 09:31 AM
Delete Part of Cell?	Odysseus[_7_]	Excel Programming	1	November 1st 04 02:46 PM
Delete Part of Cell?	Odysseus[_6_]	Excel Programming	2	November 1st 04 02:45 PM

All times are GMT +1. The time now is 08:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us