Data from Connections

I have data coming in from an existing connection onto a new spreadsheet. But not all the data shows up from the connection. cells with a number only or text only come through. However if a cell has both numbers and text the cell will not show up on the existing connection worksheet.... any ideas what the problem may be?

1234... shows up on connected worksheet
1234A... will not show up