Hi guys,

total novice I'm afraid. Here's what I'm up to.

Nearly 30 column spreadsheet of contacts. Column A is the name.

A group of people (identifiable by selecting yes on column h, one of many booleans) should have their email address (column X), but for whatever reason 84 have a blank field. Their email address is simply their name (column A) + one of usually 2 arbitrary extensions.

I only want to update the blank fields (where email address hasn't been populated).

I'd like to copy the values from column Z (which adds their name in correct dot email format to the last bit of the email address) and paste into empty cells in column X, but don't know how to do this with "non-contiguuous" lists ?

Does anyone have any ideas?

In column y, make email 1, this formula is used=LOWER(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A298," ","."),"'",""),"-",""),"è","e")))

to remove apostrophe's, replace spaces with periods, remove grave accents and hyphenation. This is then appended with the relevant suffix, using =Y298&IF(AA298="bt","@bt.com","@virgin-mobile.com")

can i copy and paste a non-contiguuous list? (ie z14,z20,z41,z43... into x14,x20,x41,x43...)

Any suggestions would be most appreciated!

Thanks in advance,
Jonny