Need SUBSTRING like function

  • Thread starter Thread starter Greg Snidow
  • Start date Start date
G

Greg Snidow

Greetings all. Let's say I have "AAAA - ABCD" in a cell. I need to extract
only the portion of text after the space after the hyphen. So, from the
example, I would need to extract "ABCD". With TSQL I can do it like this...

REVERSE(SUBSTRING(REVERSE('AAAA-ABCD'),1,4))

Or I can do...

RIGHT('AAAA - ABCD',4)

Are there any functions in Excel that would allow me to do this? In
reality, the field has a variable length before the hyphen, but the string
after the hypen is *always* = 8. Thank you.
 
Greg
If the text string to be extracted from the right hand end is *always* 8
characters then you can use =RIGHT(A1,8)
 
Thanks David and Mike. I guess I should have thought to check if Excel has a
RIGHT function. Most of the time my translating SQL into Excel is not so
gravy.
 
Back
Top