Template creation question

[decadude]

I am wanting to create an excel document maybe this needs to be a template not really sure I am by no means a pro with excel.

My needs are a heading row with formating like highlighting etc but the kicker is I need the excel document to automatically use the text to columns as a comma delimited format so when users paste in data that they copy it will go into the excel document without having to constantly select text to columns.

I know this is a small thing but I am trying to make it to where all one has to do is paste data an it is sorted automatically to the proper column without any extra hastle

thanks to all who reply and glad a resource like this site exist.

 

[decadude]

If i manually go in and do the text to columns it messes up the top heading row and only hte heading for column A exist that is one benefit to what i am trying to do the comma delimited data would already fit in the headings that I have created in the document

just need i tto already recognize and do the comma delimiter for me each time the document is opened