Conditional Concatenate

  • Thread starter Thread starter twaccess
  • Start date Start date
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
 
One way:

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

copy down as far as necessary.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate not working 2
Concatenate first:last! worksheet 5
Concantenate which keeps bold of some parts. 5
How to concatenate D1:D64? 2
Concatenate Error 1
concatenate & conditional formatting in one 1
Multiple Sumif with concatenation 5
Excel Concatenate with line breaks but ignore blank cells 3

Back
Top