How to copy first 60 words from a column since the cursor get to the end of column's content ?

[zanikos]

Hi Friends,

I try to copy first 60 words from Excel Column A1 to B1. I use this formula =left(a1,1).
When I hit F2 to rename, or double click, the cursor goes at the end of the column's content.
My big issue is that after i drag this formula =left(a1,1), I want to see first 60 words not last or middle ones.

Please help me to format my al 400 columns to copy first words with this formula, or maybe you have another method.

I wait your kind advices.