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: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532043