ST Alpha - "Amanda - LEFT and RIGHT are pretty easy. They can get pretty complex when you start nesting though. But I use them all the time." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 153

Amanda - LEFT and RIGHT are pretty easy. They can get pretty complex when you start nesting though. But I use them all the time.

Posted by JaxSean (aka JaxSean) Jan 25 '13, 13:40

If you have a cell A1 that has 904-555-1212, you can do

=LEFT(A1,7)

and it returns the left seven characters of A1, so 904-555

RIGHT does it from the right side, so

=RIGHT(A1,4)

returns the right four characters, so 1212

But then you start nesting them, like

=RIGHT(LEFT(A1,7),3)

returns the right 3 characters of the left 7 characters, which would give you 555.

Responses:

I used nested RIGHT and LEFT today with my SUMIF! -- nm - spamlet Jan 25, 13:43 1
- I read that as SMURF at first... -- nm - JaxSean Jan 25, 13:52

Post a message top

Amanda - LEFT and RIGHT are pretty easy. They can get pretty complex when you start nesting though. But I use them all the time.

Replies are disabled on threads older than 7 days.