Data Split from One Column to Another

[Mohanmoni]

Hi,

I am looking for data split from one to another column like...

"Luxottica RetailEstablishing and training the SGH Experience" Here we can see two capital letters in one word. So this as to split into 2 columns..Like my result should be..

Column1 Luxottica Retail

Column2 Establishing and training the SGH Experience


Can anyone help me with this?

Thanks,
Mohan.s

[oeldere]

@mohanmoni

Duplicated post, please stay to the other question and close this one.

http://www.excelforum.com/excel-form...ml#post3686379

[Mohanmoni]

Still problem is not solved.

[oeldere]

See the forumrules and specialy nr.5

http://www.excelforum.com/forum-rule...rum-rules.html

[Mohanmoni]

Hello Here i am expecting answer not rules!!!!!!

[FDibbins]

And we expect courtesy, not rudeness.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.