Resize cells to be able to view

[lkw441]

I have (1) cell per line that has a lot of extra data in it. Therefore
because of this I can only view (2) rows on a page. There are 1,28
rows that I have to view and extract data from. For instance, the cel
that I am concerned with has:

Pentium 100MHz CPU with 16 MB RAM and 256 KB VRAM on a PCI and ISA Bus
One Hard Drive 850 MB EIDE HD, No CD/DVD-ROM Drive, (1) 3.5'' Flopp
Drive and No Free 3.5 Floppy Bays, Two Free 5.25 Floppy Bays, PS/
Keyboard and PS/2 Mouse, 1 Parallel Port and 2 Serial Ports, Sound Car
Not Included, USB Ports Not Included, Modem of Unknown Speed Included
10BaseT Ethernet Network Adapter in a Desktop Case, NO OPERATIN
SYSTEM INSTALLED.

in it. All that I need to know is that this has a Pentium 100Mhz i
it. The rest of the data is located in other cells (such as 850M
HDD). This makes viewing it impossible. I really need some help i
possible.

Thanks.

Larry:mad

 

[neeas]

If you have a SET number of charc. that you would like to show , the
you could create another sheet and use the following:

on sheet 2 you would have your information in cell A1

on Sheet 1 Cell A1 =LEFT(Sheet2!A1,18)

will return: Pentium 100MHz CPU

You can always increase your "18" to a higher number to get mor
information.

Not sure if this will help. Good luc

 

[lkw441]

Thank you for your answer. After looking at your response, it appear
that it should work. However, if Sheet2 has the extra info (that
only need 18 characters of), would I go to the format cell icon o
tool....etc to set these rules
LEFT(Shee2!A1,18)? then would I have to copy and paste from sheet on
to 2? I've done a bit of Excel but am not familiar with this function
Thanks for your help.

Larr

 

[lkw441]

As the song says, I once was lost but now I'm found. This work
perfectly. Thanks so much.

Larry:

 

[neeas]

Great - glad to hear it


Just remember you can always extend your character numbers. I figur
you'll run into some problems down the line just because of formatin
issues, where someone puts :

Ultra2 Wide SCSI hard drive

instead of something like :

9.1Gb SCSI hard driv

 

[lkw441]

I have text '233Mhz'.....etc in a CPU Speed field. However, I cannot
get it to sort (I noticed I also have 166MHz further down in column).
I tried to change format in cell to be text but it still will not sort.
Thanks for all of your help. You guys are great!

Larry