Get external data not working properly

  • Thread starter Thread starter Kanti
  • Start date Start date
K

Kanti

Hi all,
I am "usig get external data" to fatch data from another
ecxel file to my current excel file. Everything works fine
except one thing. One of the column containd alfa numeric
data (i. e. text numbers and any combination of text and
numbers like 235521, AK558, ATT, BLD, 85455 etc). The data
in this columns shows blank cells at some places dont know
why. Has anybody came across this problem? Or is there any
solution to this?

Any help appreciated.
Thanks,
Kanti
 
I have tried to save the mixed data as text but failed.
Then I tried to trim the mixed data and this also failed.

Any other way around?
Regards,
Kanti
 
to save the mixed data as text

Sub makeText()
Dim rng as Range
Dim cell as Range
Set rng = selection.SpecialCells(xlconstants,xlnumbers)
for each cell in rng
cell.Formula = "'" & cell.Value
Next
End Sub
 
Thanks Tom.
I have run your macro but still it gives the same results. All the numbers are not desplayed. I also gone thru the KB artical. It say that the whole column will be evaluated and majority data type will be desplayed and other data type will show null.
Any other clue?
Thanks,
Kanti

----- Tom Ogilvy wrote: -----

to save the mixed data as text

Sub makeText()
Dim rng as Range
Dim cell as Range
Set rng = selection.SpecialCells(xlconstants,xlnumbers)
for each cell in rng
cell.Formula = "'" & cell.Value
Next
End Sub
 
Back
Top