Forum Discussion

Linda Rookard-McGill's avatar
Linda Rookard-McGill
Copper Contributor
Feb 23, 2017

Preceding a series of numbers with a leter

I have a file that I need to have all the asset numbers be preceded with an L.  How can I change all the numbers?  Example 0120170004 to L0120170004.

excel

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Feb 23, 2017

    Hi Linda,

     

    Depends on how you 'numbers' are formatted within the Excel. To transform from A1 cell

    If the cell is in text format text when

    ="L" & A1

    If in number format when

    =TEXT(A1,"L0000000000")

    Assuming the result is in B1 and you'd like to substitute A1 with the new value - copy B1, Paste special into A1 and delete B1 after that.

     

Resources