Show just middle info of a cell

[zeilski]

I have learned how to show just the left info (ex. - Jane instead of Jane
Smith) and right info (ex. - Smith instead of Jane Smith), but if there is
three or more words, how do I show just the middle info?

ex. - I'd like to change Jane Sue Smith to show just Sue

 

[Don Guillett]

Look in the help index for
LEFT
RIGHT
MID

 

[zeilski]

That helps a little. But what if the starting character and the number of
characters differs?

Sally Joe Johnson
Suzanne Peggy Jefferson

 

[Don Guillett]

Then use FIND or SEARCH to find the starting point for you MID

 

[David Biddulph]

=MID(A1,FIND(" ",A1)+1,FIND(" ",MID(A1,FIND(" ",A1)+1,999))-1)

 

[Reitanos]

As was said already, MID, RIGHT, LEFT, and FIND are great for taking
pieces out of strings, but don't forget to error check (ISERROR is
handy). People with no middle name cause errors - and pray that Cher
does not show up in your list