11 Feb 2009 at 20:22 #1 xirokx xirokx Soldato Joined 2 Oct 2004 Posts 4,362 Location N.W London Hi Guys, If I had the following:- cell a1 a2 15d 15 And I want to enter a formula to seperate the d from the 15 so in cell a2 there is 15 only how can I do this? what formula could I use? Please advise.. Cheers
Hi Guys, If I had the following:- cell a1 a2 15d 15 And I want to enter a formula to seperate the d from the 15 so in cell a2 there is 15 only how can I do this? what formula could I use? Please advise.. Cheers