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