I several cell in a column I have data that reads for example:
123456.xls (note six numbers before the dot)
1234.xls (note four numbers before the dot)
I want to keep everything BEFORE the dot and paste it in a new column to the right of the existing column. How can I do this?