Dear Sir,

I know Text to column option in excel but i want formula for this.when I paste data (Report Name) or overwrite in column C then all text spilt in each column.I solved this issue in above sheet as per my try,pls see.

Regards
Amar