LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete middle word from a cell Wanna Learn Excel Discussion (Misc queries) 5 October 19th 06 05:08 PM
I want data to show in the cell only when the info is inserted Rebecca Excel Worksheet Functions 1 April 23rd 06 04:51 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM
how to remove spaces in a middle of a cell example '25 566 589. P.M.SANJAY Excel Discussion (Misc queries) 1 January 6th 06 07:23 PM
How do I show info only in cells used Kev Excel Discussion (Misc queries) 1 December 17th 05 11:03 AM


All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"