Problems with Text values in Excel.

G

gacollege

I have a list of 1,000 values 900 are numeric values and 100 of them are
text values. What problems could arise when working with this list? I
know sorting will not put part 1001 and 1001-ST together, but at one
time I recall VLOOKUP giving me a glitch when trying to pull data from
a list of numeric and text values.

Richard
 
N

Niek Otten

<VLOOKUP giving me a glitch >

Yes, and maybe many others.

If some of them contain letters, it is probably better to make them all text.

=text(a1,"0") or some other formatting string
 
G

gacollege

Niek said:
<If some of them contain letters, it is probably better to make them all
text>


I kind of was thinking that..but from what little I have read - if you
take a data dump from a .txt file and convert to Excel - you have to
rekey the text values. Which defeats the beginning purpose. In
addition - I think the sort function will become void at this point?

At this point upper management (not fluent in Excel) is looking at
dumping a lot of text data into numeric data and I am concerning this
will cause havic on any Excel spreadsheets that I may have.

Richard
Click to expand...
 
Top