Number and Text Column

[svanjo]

Hi

I am hoping someone can help me as this is now driving me mad.

I have a workbook where I have set up the import external data. The data it is importing is from an excel spreadsheet. For some reason it imports all the data correctly except for one column (purchase order column). The only reason I can think it may have a problem is because the column contain numbers only as well as text and numbers. (i.e. 958759 and IWP05478). I have tried changing the format of the column to general and to text but still no joy.

If anyone can offer a solution to this problem it would be greatly appreciated.

Thank you

Stefanie Vanjo

 

[BrianB]

1. Select the column and format it as text.
2. From the menu do Data/Text to Columns .... Finish

You might be interested in this
http://www.mrexcel.com/board2/viewtopic.php?t=182253&highlight=

 

[svanjo]

Thank you. That worked a treat.