Input a value in a cell IF another cell contains a value

[Chrulf]

I think this is a tricky one.
I have a sheet where I paste different amounts of rows every time I use the sheet. I want the cells below C2 to show "TEXT" only if the cells below B2 contains value as I show on the image. If I paste 6 rows below B2, I want 6 rows below C2 to show "TEXT" in every cell. The problem is that I can not have any formulas below row 2 because its gonna be saved as a CSV file. Is this possible?

 

[etaf]

if you save a CSV , you should just have the results not the formula, at least thats what i get


=IF( B3 ="" , "" , "TEXT")

 

[Chrulf]

Thats true, but then I have to insert the formula into every cell below C2 (C:C), right? I tried 10 rows with the formula but the program I use notice any value in all rows, so the value in C3:C13 will produce a ";" for every row.. I save as CSV Comma Separated Values File.

 

[etaf]

Ok, then maybe a VBA solution is needed , not my expertise now , sorry