left, right,mid?

  • Thread starter Thread starter stumped
  • Start date Start date
S

stumped

Can someone please post code for finding the last value
after the last comma in a string? For example, in the
string:
SplitDummy,"SplitDummy","","","",36,3,8
I need the last value. This is a variable length string
and the last value could be a single, double, or triple
digit value.

Thank you
 
Hi
one way: use the following array formula (entered with
CTRL+SHIFT+ENTER)
=MID(A1,MAX(IF(ISNUMBER(--MID(A1,ROW(INDIRECT("1:1024")),1)),ROW(INDIRE
CT("1:1024"))))+1,10)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
I need help with this program written in Visual Basic for Excel 2007. 4
Excel Functions 6
Cut the last 20 characters out of a text string 4
Excel Macro to automatically go to the right of the last colored cell 0
Extract text in middle using Mid and Find or Search 5
VBA: How can I use a string variable as autofilter criteria? 4
Access 2007,reports,VBA 2

Back
Top