Feb 23 2017 01:17 PM
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.
Feb 23 2017 02:44 PM
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.