Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split astring using Capital letter as identifier
Hi,
I am looking for a formula/function/UDF that would split VasantRamPatil into Vasant Ram Patil ( ie split the string into three words using the capital letter as the initial letter of each word). The split can be either by inserting spaces inside the string itself or splitting the string into three strings). Thanks in advance for the Help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Capital Letter | Excel Worksheet Functions | |||
changed to capital letter | Excel Discussion (Misc queries) | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
Turn to capital letter | Excel Discussion (Misc queries) |