Numbers (and Excel) reads this as straight text. After importing, you can select the column and explicitly set it to text via the Format Inspector > Cell > Data Format, where you choose Text.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

Trying to make all of the text or words fit properly in your Excel spreadsheet? Learn how to make text fit in Excel with our tutorial.

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell ...