set variable for string after first underscore

		Microsoft Office Forums > Microsoft Excel > Excel Programming
set variable for string after first underscore

FAQ

Thread Tools

Display Modes

07-09-2018, 11:05 AM

charlesdh

Windows 7 32bit set variable for string after first underscore

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

set variable for string after first underscore

HI,

I'm having a senior moment.

I'm wanting to get text after the first underscore.
My data look s like this:
z_WWWWW_PR
zzz_AAAA_pk

What I'm looking for is:
WWWWW_PR
AAA_pk
I've search for a answer and found something close to what I want but it remove both underscores.
Any help appreciated.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assigning a string variable to a userform label caption	Larry_1	Excel Programming	3	12-18-2017 06:59 AM
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Emails to recipients with underscore in email address not received	gjskerritt	Outlook	0	03-14-2017 06:27 PM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Why unable to use underscore in microsoft word styles( user defined)?	noufalcm	Word	1	03-08-2011 01:46 PM