Hello all how are we this fine morning?
I was wondering if you can add more to a substitute formula?
Currently I'm using three substitute formulas and was trying to merge them all to where I just have one formula instead of three.
I've included an example.
thx,
mrggutz
Last edited by mrggutz; 02-18-2011 at 08:54 AM.
Here, try this:
=SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A2,"\",REPT(" ",100)),100)),".xls",""),"-","")
Never use Merged Cells in Excel
Dude that is like awesome thx for the help it works great...yea
have a great weekend.
mrggutz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks