| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete middle word from a cell | Excel Discussion (Misc queries) | |||
| I want data to show in the cell only when the info is inserted | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| how to remove spaces in a middle of a cell example '25 566 589. | Excel Discussion (Misc queries) | |||
| How do I show info only in cells used | Excel Discussion (Misc queries) | |||
Linear Mode
