Hi

Use a blank column with the formula:
="ab"&A2
where A2 contains your number.
Once you have filled this down the column, select them all and Ctrl+C
(Copy). Then select Edit/Paste Special/Values to fix the values in place.

Hope this helps.
Andy.

"Riza" wrote in message
...
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.