I am a total beginner and I am at a loss on how to achieve this. My goal would be instantly create a file index based on a file list I import into excel. I would like to take something like the following text in a cell...
“01 Draft Discussion Document - Appendix A.pdf” and have it changed to
“Tab 01__________Draft Discussion Document - Appendix A”.
I cant figure out how to go about this smartly.
Is there way to add (10 spaces) at the position of the first space, add “Tab” at the front, and delete the (.pdf/.PDF) at the end? I would want to apply this to all the cells that contain text in Column A.

* I had to use underscores in my example above, in its place would be 10 spaces.

Thanks very much.