OK.. If I have product numbers in column A of a file, and I want to add a couple characters to the beginning of each number.
example.. code is "123".. I want the code to be "FF123" is there a simple way to do this?
Either an add command, or even creating a whole column of "FF" and them merging them?
I do not wish to do this manually by editing as there are THOUSANDS of rows to edit.
thanks!
example.. code is "123".. I want the code to be "FF123" is there a simple way to do this?
Either an add command, or even creating a whole column of "FF" and them merging them?
I do not wish to do this manually by editing as there are THOUSANDS of rows to edit.
thanks!