Conditional Concatenate

T

twaccess

Hi all.

Its been a while since I was last here. I'm wondering if its possibl
to devise a formula which concatenates a sentence in column B each tim
there's an occurence in column A ?

Thanks


T
 
J

JE McGimpsey

One way:

B1: =IF(A1<>"",A1 & " starts this sentence.","")

copy down as far as necessary.
 
Top