+ Reply to Thread
Results 1 to 2 of 2

pasting values into EMPTY cells

  1. #1
    Registered User
    Join Date
    09-27-2007
    Posts
    9

    pasting values into EMPTY cells

    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

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875
    Hi,
    Lets see an example workbook..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1