Substring expression help

**sbell1234** · 06-21-2015, 01:54 PM

If SUBSTRING() is a function that returns part of a text string based on a specific starting position and a specific number of characters, such that SUBSTRING('Mt. Rushmore',5,4) = 'Rush', write a SUBSTRING() expression to isolate America's third president's first name from the following string: 'Jefferson, Thomas

**sktneer** · 06-21-2015, 02:32 PM

There are several ways to get the desired output in this case.
Lets assume that you have Jefferson, Thomas in A1, then see what the following formulas will return....

Please Login or Register  to view this content.

In the above formula, you are trying to extract everything from the right of the string after the Space. So with the Find function, you find the position of space character and use Right function to get everything after the space character. So the above formula will return Thomas.

Please Login or Register  to view this content.

In this formula, you are trying to extract everything from the left before the comma. So with the Find function in this case, you find the position of comma in the string and with the help of Left function, you get everything before the comma in the string. The above formula will return Jefferson.

Hope this helps.

**sbell1234** · 06-21-2015, 02:37 PM

Thanks sktneer.

Could you help with this?

If LEFT('dog',1) = 'd' and RIGHT('dog',2) = 'og', then what is: LEFT(RIGHT('transparent',7),5)?

**Pepe Le Mokko** · 06-21-2015, 02:38 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/access-tab...pressions.html