Assuming all the numbers are in Col A, and are on consecutive rows, in Col B
write =€�ab€�&A1. Then highlite your whole Col B range, copy, paste special
values. Move it to Col A and youre done.

"Riza" wrote:

I have like 5000 different data and I need to add letter ab in front of them.
Could anyone tell me how to do this.

for example 123 is what it says but I need ab123 and each row is different
number.