Hi,

Am Sat, 18 May 2013 14:06:42 +0100 schrieb lostgrave2001:

hello
i have the following text in cell A2
123456 batman £15000.00
i would like to be able to coy just the £ amounts in to cell D2.

in D2 try:
=MID(A2,FIND("£",A2),99)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2