Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-09-2018, 11:05 AM
charlesdh charlesdh is offline set variable for string after first underscore Windows 7 32bit set variable for string after first underscore Office 2010 32bit
Expert
set variable for string after first underscore
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default 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
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
set variable for string after first underscore 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
set variable for string after first underscore Why unable to use underscore in microsoft word styles( user defined)? noufalcm Word 1 03-08-2011 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft