If you want to apply a formula to an entire column in Excel, use the Fill down option, or use other great methods from this guide.

How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.