If Cell Blank ignore, otherwise Concatenate

[davidbfranks]

Hi Guys,

Wondering if you could assist me with this simple formula -

I'm trying to combine, "column E" with "column D" with a "." in between, I did the first one as an example - "BQ6924-001" add the "." and then the "3.5UK" so we get "BQ6924-001.3.5UK"

I want to ignore the blanks though in column "D"

So need a formula like "If Column D is Blank Ignore, otherwise, Combine "F" with "E" with "." in the middle

Thanks, appreciate any help.

David

 

[AlanY]

try in F1

=if(isblank(D1),"",E1&"."&D1)

 

[davidbfranks]

try in F1

=if(isblank(D1),"",E1&"."&D1)

Perfect, thank you very much!

 

[AlanY]

you're welcome