 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Show just middle info of a cell
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 Look in the help index for LEFT RIGHT MID  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >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 That helps a little. But what if the starting character and the number of characters differs? Sally Joe Johnson Suzanne Peggy Jefferson > Look in the help index for > LEFT [quoted text clipped - 6 lines] > > > > ex. - I'd like to change Jane Sue Smith to show just Sue Then use FIND or SEARCH to find the starting point for you MID SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > That helps a little. But what if the starting character and the number of > characters differs? [quoted text clipped - 14 lines] >> > >> > ex. - I'd like to change Jane Sue Smith to show just Sue =MID(A1,FIND(" ",A1)+1,FIND(" ",MID(A1,FIND(" ",A1)+1,999))-1) -- David Biddulph > That helps a little. But what if the starting character and the number of > characters differs? [quoted text clipped - 14 lines] >> > >> > ex. - I'd like to change Jane Sue Smith to show just Sue 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 ;) > =MID(A1,FIND(" ",A1)+1,FIND(" ",MID(A1,FIND(" ",A1)+1,999))-1) > -- [quoted text clipped - 23 lines] > > >> > ex. - I'd like to change Jane Sue Smith to show just Sue |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.