Have you tried Data - Text to Columns...
--
HTH...

Jim Thomlinson


"Knox" wrote:

Does anyone know a code or function that will take two numbers seperated by a
comma in a cell and put them in two seperate cells? For instance taking
85.443,33.45 in a cell and putting 85.443 and 33.45 in two seperate cells. I
need to do this for a lot of rows. thank you!