Hi,
I have a name in cell a1 (arun kumar gupta). I need out put in cell b1 as (arun k gupta,arun gupta,gupta arun,arun kumar,arun kumar g,g arun kumar,a k gupta).
Kindly show me with formula how to split "arun kumar gupta" with various name combinations as i mentioned above into single cell followed by comma(,).
Can anyone help me.....
I looking forward your response.
I have a name in cell a1 (arun kumar gupta). I need out put in cell b1 as (arun k gupta,arun gupta,gupta arun,arun kumar,arun kumar g,g arun kumar,a k gupta).
Kindly show me with formula how to split "arun kumar gupta" with various name combinations as i mentioned above into single cell followed by comma(,).
Can anyone help me.....
I looking forward your response.
Last edited: