₦airaland Forum

Many thanks for checking this thread, please i need your help.
I have this numers in a row

8024462298 
8063362834 
8064441979 
8066900050 
8147317462 
8156514583 

But i want to turned it to something like this

abc+18024462298@email address.com
abc+18063362834@email address.com
abc+8064441979@email address.com
abc+8066900050@email address.com
abc+8147317462@email address.com
abc+8156514583@email address.com 

Any help on how i can do this please?

Just add ' before the abc

kintus:
Just add ' before the abc

How please?

Before writing and ensure you start with '

kintus:
Before writing and ensure you start with '

I still do not get it.
do you have a complete formular for this
Im looking at should i do for one and copy down for the rest?

kintus:
Before writing and ensure you start with '

Well i eventually find a solution to it.
thanks, i appreciate.

Share with us here sir

You should use a function called concatenation.. Create 3 columns the first columns should have the ABC, the second column should have the numbers and the third colum should have the @gmail.... So to get them together you will type "=concatenate then select the first colum followed by a comma then select the second column followed by another comma then select the third column then click on the enter button... I.e" =concatenate, column 1,column 2,column 3 enter.. The whole text will come together as one.. You can then drag down to effect the formulas on other rows.