Extracts string of numbers from cells and add an email extension, aidez moi sil vous plait!

Dear friends my name is Maeve and I am a PhD student

I need to create a database of emails of schools to contact for my dissertation on education. this district of my sample does not have a list so it would take me forever to do one by one.

i exported something on a .cvs file and it looks like this:

04000080;"C.E.I.P. San Fernando";"Adra";"";"";"sí";"";"";"sí";"";"";"";"sí";"sí";"";"sí";"";"";"";"sí";"sí";"sí";
04000110;"I.E.S. Abdera";"Adra";"";"";"sí";"";"";"sí";"";"";"sí";"sí";"sí";"sí";"sí";"";"";"";"sí";"sí";"sí";
04000134;"I.E.S. Gaviota";"Adra";"";"";"sí";"";"";"";"";"sí";"";"";"sí";"";"sí";"";"";"";"sí";"sí";"sí";
04004383;"C.E.I.P. Torrequebrada";"Aguadulce";"";"";"sí";"";"";"";"sí";"";"";"";"";"";"sí";"";"";"";"sí";"";"";
04005594;"C.E.I.P. Arco Iris";"Aguadulce";"";"";"sí";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"sí";"sí";
04601646;"C.E.I.P. Blas Infante";"Aguadulce";"";"";"sí";"";"";"";"";"";"";"";"";"";"sí";"";"";"";"sí";"sí";"sí";

I need to extract the numbers from those cells and add an email extension like for example @gmail.com so it would look like:

04000080@gmail.com
04000110@gmail.com
.
.
.
.

I lack the knowledge for doing this so pleeeeeeease help me out!!

merci,

Maeve

Nick's picture

paste the data in Excel in

paste the data in Excel in cell A1
then go: Data=>text to columns=>delimited=> Next=> put this: ; in the other field

then OK that, and you'll have your numbers... from that, setup a formula:

=A1&"@gmail.com"

... copy that formula down..