software

Hi Everyone,
I have 2 companies parts in a spreadsheet. One set is uppercase and
one is lowercase. Example:
10x06-398f 4.54
10X6-398F 6.56

I would like to highlight the lowercase parts to
1. Find all of company number 1's price.
2. Make these two entries into one line:
10X6-398F 6.56 4.54

Any help you can give me will be greatly appreciated!
Lori--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: www.excelforum.com/member.php...foamp;userid=2815
View this thread: www.excelforum.com/showthread...hreadid=532043Use conditional formatting with a formula of

=EXACT(LOWER(A14),A14)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;LoriM1quot; gt; wrote in
message ...
gt;
gt; Hi Everyone,
gt; I have 2 companies parts in a spreadsheet. One set is uppercase and
gt; one is lowercase. Example:
gt; 10x06-398f 4.54
gt; 10X6-398F 6.56
gt;
gt; I would like to highlight the lowercase parts to
gt; 1. Find all of company number 1's price.
gt; 2. Make these two entries into one line:
gt; 10X6-398F 6.56 4.54
gt;
gt; Any help you can give me will be greatly appreciated!
gt; Lori
gt;
gt;
gt; --
gt; LoriM1
gt; ------------------------------------------------------------------------
gt; LoriM1's Profile:
www.excelforum.com/member.php...foamp;userid=2815
gt; View this thread: www.excelforum.com/showthread...hreadid=532043
gt;

Thank you!!!!
Lori--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: www.excelforum.com/member.php...foamp;userid=2815
View this thread: www.excelforum.com/showthread...hreadid=532043