|
Show 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 |
Show just middle info of a cell
Look in the help index for
LEFT RIGHT MID -- Don Guillett Microsoft MVP Excel SalesAid Software "zeilski" wrote in message ... 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 |
Show just middle info of a cell
That helps a little. But what if the starting character and the number of
characters differs? Sally Joe Johnson Suzanne Peggy Jefferson "Don Guillett" wrote: Look in the help index for LEFT RIGHT MID -- Don Guillett Microsoft MVP Excel SalesAid Software "zeilski" wrote in message ... 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 |
Show just middle info of a cell
=MID(A1,FIND(" ",A1)+1,FIND(" ",MID(A1,FIND(" ",A1)+1,999))-1)
-- David Biddulph "zeilski" wrote in message ... That helps a little. But what if the starting character and the number of characters differs? Sally Joe Johnson Suzanne Peggy Jefferson "Don Guillett" wrote: Look in the help index for LEFT RIGHT MID -- Don Guillett Microsoft MVP Excel SalesAid Software "zeilski" wrote in message ... 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 |
Show just middle info of a cell
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 ;) On May 20, 11:46 am, "David Biddulph" <groups [at] biddulph.org.uk wrote: =MID(A1,FIND(" ",A1)+1,FIND(" ",MID(A1,FIND(" ",A1)+1,999))-1) -- David Biddulph "zeilski" wrote in message ... That helps a little. But what if the starting character and the number of characters differs? Sally Joe Johnson Suzanne Peggy Jefferson "Don Guillett" wrote: Look in the help index for LEFT RIGHT MID -- Don Guillett Microsoft MVP Excel SalesAid Software "zeilski" wrote in message ... 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 |
| All times are GMT +1. The time now is 10:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com