LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Siple but what was the formula for splitting names?

Hi,
I need the formula for splitting names...
i.e need "Martyn Williams" in A1 to be splitted to "Martyn" and "Williams"
in B1 and C1
TIA


 
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
Splitting names [email protected] Excel Discussion (Misc queries) 4 January 12th 07 08:44 PM
splitting names can't see whats going wrong (Save My Sanity ) workaholic Excel Worksheet Functions 5 November 8th 05 04:19 PM
Siple formula with a twist Mike Busch Excel Discussion (Misc queries) 1 August 30th 05 05:06 PM
Question for Bob Phillips re Splitting Names from Cells Paul Sheppard Excel Discussion (Misc queries) 8 August 3rd 05 09:00 AM
Splitting names from cells GoesLikeStink Excel Discussion (Misc queries) 2 July 30th 05 07:16 AM


All times are GMT +1. The time now is 07:26 PM.

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"