Posted to microsoft.public.excel.misc

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

Edit Replace formula

Highlight your range

In the menu click EditReplaceFind What:press space bar TotalReplace With:
<leave it blank, then click Replace All

"snax500" wrote:

In Excel2000, I need a formula that will replace text string. For
example, I have the following text:
Boston Total
New York Total

I want a formula to just give me

Boston
New York

I don't want to use the Edit Replace, I want a formula.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Find value in array	Brook6	Excel Worksheet Functions	26	January 30th 07 09:40 PM
IF formula in Excel / Replace numbers with 'words'	Emsmaps	Excel Discussion (Misc queries)	1	April 7th 06 11:01 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
edit formula bar in excel 2003?	alnav89	New Users to Excel	1	April 27th 05 06:10 PM

All times are GMT +1. The time now is 04:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us