| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Siple but what was the formula for splitting names?
Martyn hu kiteb:
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 Others have proposed solutions. Just be aware that not all names will fit this pattern. Consider Soo Cheon Jheong as an example. Peter van helsing is another example that breaks the pattern. Computer programmers that think they know how my name should be spelt and capitalised is a pet peeve of mine. Companies have lost my account over it before, including one that tried to argue with me face to face over the spelling. The software had truncated my surname at the space. -- -- Fabian Visit my website often and for long periods! http://www.lajzar.co.uk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting names | Excel Discussion (Misc queries) | |||
| splitting names can't see whats going wrong (Save My Sanity ) | Excel Worksheet Functions | |||
| Siple formula with a twist | Excel Discussion (Misc queries) | |||
| Question for Bob Phillips re Splitting Names from Cells | Excel Discussion (Misc queries) | |||
| Splitting names from cells | Excel Discussion (Misc queries) | |||
![Fabian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
