Concatenate IF cell is not empty

[chet]

Evening all,

I have a simple spreadsheet that I'm currently building that I require help in with a couple of areas, I may need a macro so I will post that on a different thread.

I've attached my spreadsheet which has two worksheets, Input and 1. Phone (Jabber), I populate the 2nd worksheet from the Input worksheet with the aid of Concatenate, I would like to know how to achieve the following please.

If I have and empty cell I want another cell to be emptied, looking at my 2nd worksheet in cell A4 you will see I have the formula =IF(C4="","","FILLED") this is my just testing I can make the cell empty and then populate with the word FILLED.

What I would like to achieve is instead of saying FILLED I can pull data from the Input worksheet =CONCATENATE("CSF",UPPER(Input!E3))
So basically if the C4 is empty leave A4 blank, if not then =CONCATENATE("CSF",UPPER(Input!E3))

Hope this makes sense and hope you can also let me know how to achieve this.

Many thanks,
Chet

[Sam Capricci]

is this what you are saying you want?
=IF(C2="","",CONCATENATE("CSF",UPPER(Input!E2)))

[chet]

Perfect, thanks for your time and help.