What are the rules? Why is Sony ericsson SE whilst Nokia is NOK?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"themax16" wrote in
message ...

Afternoon everybody....

I have a pair of text based lists running down a worksheet.. i need to
create a 3rd list that is made up from the information in lists one and
two.

Eg.

List one List two List three (PLU)

Sony ericsson P900 SE P900
Nokia 6230 NOK 6230

As you can see the LPU is extracted from the Make and model.
Is it possible to set up some formulation for this?

Thanks
James


--
themax16
------------------------------------------------------------------------
themax16's Profile:
http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=390520