How toformart this in Excel please?

[ronyking247]

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

8024462298
8063362834
8064441979
8066900050
8147317462
8156514583

But i want to turned it to something like this

abc+18024462298 at email address
abc+18063362834 at email address
abc+8064441979 at email address
abc+8066900050 at email address
abc+8147317462 at email address
abc+8156514583 at email address

Any help on how i can do this please?

[ronyking247]

I will appreciate urgent response here!

[GeoffW283]

Assuming your list starts at A1 then in B1:
="abc + 1" & A1 & " at [email protected]"

If this is not exactly what you want (and I suspect it isn't) then please specify in more detail exactly what you expect.

[ronyking247]

Many thnaks Bro,
Exactly what i wanted. but after i have done it, but leaves a space inetween.
the result was abc+1595959595 atemail addresss

how can i make the 'at' sign close to the number?

[ronyking247]

I do noticed the numbers when i copied it to notepad, it has this imaginary space but how can i close those space in excel so that from where the number start and end is where will be on.

ut i think that is why its causing that space in between the 'at' sign and the last digit of the number.

[GeoffW283]

Like this?

="abc + 1" & A1 & "at [email protected]"

The stuff between the double quotes is simply text - you can add or take away whatever you like within the quotes.