LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
gacollege
 
Posts: n/a
Default Problems with Text values in Excel.


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


--
gacollege
------------------------------------------------------------------------
gacollege's Profile: http://www.excelforum.com/member.php...fo&userid=1518
View this thread: http://www.excelforum.com/showthread...hreadid=521639

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import text to Excel Fredrik E. Nilsen Excel Discussion (Misc queries) 2 November 21st 05 06:55 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
how do I convert copied Text numbers into values in Excel? MOE Excel Worksheet Functions 1 June 14th 05 06:03 AM
setting text qualifier in Excel Lyle Excel Discussion (Misc queries) 1 June 8th 05 06:28 PM
Problems Autosaving an excel file/sheet as Text MaxFrance Excel Discussion (Misc queries) 0 March 25th 05 09:49 AM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"