One way is to insert a column and use the following formula:

=concatenate("ab",A1)

[assuming Column A contains your original number]


"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.