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.
Hi Katstorm
You can use two options to add letters with numbers, one is through custom format as mentioned below: Simply select the whole column (or required rows) and define custom format as "AB"###0
Alternatively you can use Concat() function to add desired text with numbers.
Thanks
Tauqeer
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.