copying specific text from cell

  • Does anyone know of a formula that will automatically copy a specific range of digits in a cell.


    Example. I have a cell that contains 1125566348 98. Is there a function in that can copy the first 10 digits?


    Thanks

  • Re: copying specific text from cell


    Note that the LEFT() function will return the result as TEXT. If by any chance you want to do math with the 10-digit returns, use the VALUE function in conjunction with LEFT() to turn the results back to a number.
    =VALUE(LEFT(A1,10))

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!