| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse A String into Two
You are welcome
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "xlmate" wrote in message ... Thank you for your effort and solution Appreciate it Thank You cheers, francis "Ashish Mathur" wrote: Hi, You can try this array formula (Ctrl-Shift+Enter) =MID(A10,MATCH(TRUE,EXACT(MID(A10,ROW($1:$28),1),P ROPER(MID(A10,ROW($1:$28),1))),0),MATCH(TRUE,EXACT (MID(A10,ROW($2:$28),1),PROPER(MID(A10,ROW($2:$28) ,1))),0))&" "&MID(A10,MATCH(TRUE,EXACT(MID(A10,ROW($2:$28),1), PROPER(MID(A10,ROW($2:$28),1))),0)+1,255) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "xlmate" wrote in message ... I can't remember how do I separate the text into two by finding the 2nd upeer case. eg SmithJohn to Smith John -- Appreciate your help. Thank You cheers, francis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parse text string | Excel Worksheet Functions | |||
| Parse this string | Excel Discussion (Misc queries) | |||
| How to parse a string with a date? | Excel Worksheet Functions | |||
| Parse data where break is a first uppercase character in a string? | Excel Worksheet Functions | |||
| Q: parse string | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
