IF command to find blank cells and replace with email address

[courika]

I'd like to do exactly the title for cells A1 through A5830 so I can import a CSV into Exchange

In the same workbook, I'd love it if I could combine C1-C5830 and D1-D5830. These are first name and last names of people I'm importing.

If you can help, I'd so appreciate it! It's driving me crazy!

Thank you.

Sean

 

[FDibbins]

1. formulas cannot affect other cells, so if you want to apply this change to A1:A5820 itself, you would need VBA (code)
2. Where would this "email address" come from?
3. You could do this with a helper column, =using something like...
=if(a1="",email addy ref, A1)
copied down

For the 2nd part, a simple =C1&" "&D1 copied down should do it

 

[Joe4]

Welcome to the Board!

Concatenating cells is pretty easy.
So if First Name is in column C, and Last Name is in column D, and you want to return the full name separated by a space, just use this formula:

=C1 & " " & D1

Regarding filling the blank cells, do the following:
- Highlight all your data in column A (from first row with data to last)
- Press F5
- Click "Special"
- Select the "Blanks" radio button and press OK
- Type in the email address you want and hit CTRL-ENTER

 

[courika]

Welcome to the Board!

Concatenating cells is pretty easy.
So if First Name is in column C, and Last Name is in column D, and you want to return the full name separated by a space, just use this formula:

=C1 & " " & D1

Regarding filling the blank cells, do the following:
- Highlight all your data in column A (from first row with data to last)
- Press F5
- Click "Special"
- Select the "Blanks" radio button and press OK
- Type in the email address you want and hit CTRL-ENTER

Awesome, thank you for the help. I've decided that if they don't have email addresses they shouldn't be in the address book. However, I ran the code for combining the first and last name in an empty cell, and it did great but put the values in the empty cell. Duh, I get it but I need the last name to join the first name in the C cell, and it needs to be for almost 6000 contacts (5830 to be exact). What would that formula look like and from where would I run it so it didn't populate an empty cell?

Thank you so much in advance.

 

[TonyUK72]

Simply copy the combined cells (Column D) and then "Paste Special" Values Only into Column C

** EDIT You can then delete column D **

 

[FDibbins]

For the 2nd part, a simple =C1&" "&D1 copied down should do it

adjust to this...

=if(C1="","",C1&" "&D1)
copied down