Forum Discussion
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.
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.