separate text and numbers

  1. K

    Solved split numbers & text in a single cell into 2 cells, xl2007

    Hi I have a column of data which contains a reference followed by the customer name. examples:- Cell B1: 0111213729 rivett luke Cell B2: 0122022157 fernandes de souza henrique Cell B3: 0803141945 lopez fernandez eduardo I am using excel 2007 and want to find the code to separate the number...