Posted to microsoft.public.excel.worksheet.functions

Joe Gieder

Posts: n/a

REPLACE or ??, Help please

First, Thank you for all the help and support.

I have a many cells similar to 01037DL530001-101 and want to remove
everything from the "-" to the end. I tried replace but can't seem to get it
to work. The one thing to keep in mind is that the numbers of characters or
numbers varies after the dash.

Thank you for your help
Joe

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
Edit Replace	Zee	Excel Discussion (Misc queries)	1	January 5th 06 08:56 PM
find replace format	neeraj	Excel Discussion (Misc queries)	6	September 20th 05 05:50 PM
Search and replace	Subu	Excel Worksheet Functions	4	June 9th 05 07:01 PM
replace absolute references	bj	Excel Worksheet Functions	0	May 20th 05 07:18 PM
REPLACE outside of highlighted column	Jane	Excel Worksheet Functions	8	May 19th 05 01:54 PM

All times are GMT +1. The time now is 10:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us