Preceding a series of numbers with a leter

[Linda Rookard-McGill]

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.

[#2]

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.