Forum Discussion
Adding letters to an existing column of numbers
I need to know how I can add letters to an existing column of numbers. I need to add the same two letters before each group of numbers. Flash fill is not doing it for me, or I'm doing it wrong.
Appreciate the info, it worked with a slight modification. As mtarler had mentioned your 1st suggestion works if I don't need the underlying code and just need the visual. However as these numbers are from product code and I would be uploading to a database, I need it to read the whole thing. I took a short cut, I used your suggestion to format the range of cells using the "AB"####, then copied and pasted into OneNote, then copied and pasted back and it worked. Thanks for the hand up, it's appreciated.
