In one of the column of excel, the data contains data with numeric and some data with characters. How can I convert the data type of the column to Text.

I tried to use the DigDB AddIn (Convert Excel Data Types - from Text to Number/Date (General), vice versa - Excel Tips & Add-ins) and now the AddIn in my PC has expired.

I need to perform the similar task (to convert the data type to Text).

Thanks.

Hi,

If I understand your question correctly, select the column, right click | format, and choose the "Text" category.