Posted to microsoft.public.excel.misc

pokdbz

external usenet poster

Posts: 43

Removing text

I have a variable and I need to remove everything after the last "_" in a
string including the "_".

Example
abc_def_ghi_jklmnop

Result: abc_def_ghi

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
Removing text	Dave	Excel Discussion (Misc queries)	13	July 23rd 08 09:02 PM
removing blanks at the end of text	Roger	Excel Worksheet Functions	5	December 12th 06 08:52 PM
Removing Text	Tubthumper	Excel Worksheet Functions	3	October 19th 06 06:29 PM
Please help with removing text string	excelator	Excel Discussion (Misc queries)	3	August 15th 06 12:08 AM
Removing text characters	Scott	Excel Worksheet Functions	4	August 11th 05 12:19 PM

All times are GMT +1. The time now is 06:45 AM.

About Us

"It's about Microsoft Excel"