Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

taking a word out

On Tue, 18 Aug 2009 12:44:13 -0400, Ron Rosenfeld
wrote:

=substitute(a1,"Average","")

should be =substitute(a1," Average","")
--ron

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
Taking a list	LittleC	Excel Discussion (Misc queries)	0	November 18th 10 01:23 AM
Sumif but taking a value	Mosqui	Excel Worksheet Functions	5	October 28th 09 02:22 AM
Taking Flat Data in Excel and Making it Relational in Word	[email protected]	Excel Programming	0	November 20th 08 08:39 PM
taking two worksheets together	Jens Ravens	Excel Worksheet Functions	3	June 3rd 06 07:48 AM
Taking Attendance	L.Paul	Excel Discussion (Misc queries)	2	April 19th 05 08:27 PM

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

About Us

"It's about Microsoft Excel"