i wish to change a cell that contains "27809980" to "27.809.980" it is a text cell
F fazz May 29, 2008 #1 i wish to change a cell that contains "27809980" to "27.809.980" it is a text cell
A Andrea Jones May 29, 2008 #2 You can use a formula in another cell: =CONCATENATE(LEFT(A1,2),".",MID(A1,3,3),".",RIGHT(A2,3)) Andrea Jones www.stratatraining.co.uk www.wrekinpublishing.com
You can use a formula in another cell: =CONCATENATE(LEFT(A1,2),".",MID(A1,3,3),".",RIGHT(A2,3)) Andrea Jones www.stratatraining.co.uk www.wrekinpublishing.com
S Sandy Mann May 29, 2008 #3 =LEFT(A1,2)&"."&MID(A1,3,3)&"."&RIGHT(A1,3) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings [email protected] Replace @mailinator.com with @tiscali.co.uk
=LEFT(A1,2)&"."&MID(A1,3,3)&"."&RIGHT(A1,3) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings [email protected] Replace @mailinator.com with @tiscali.co.uk