Concatenate and IF function

Hello, I am currently using the following formula to concatenate a 4 columns

=CONCATENATE(G11,IF(H11="","","-"),H11,IF(I11="","","-"),I11,IF(J11="","","-"),J11)

The result will show in column A.

I need to add an extra column that it will "only" show in column A once the prior formula is done. For example:

Now, column name output:

DB-DB_Oracle-10.10.10.11(1)-oracle


I need:

EMEA_PL_9-DB-DB_Oracle-10.10.10.11(1)-oracle ==> the number after EMEA_PL_ must be sequential and it can be obtained from Sheet1, column F.

Also, until the values are not added in columns G, H, I, J; EMEA_PL_## should not show up in column A.


I have attached a file with the example.

thanks

Hi
See if this helps

Formula:

Please Login or Register  to view this content.

thank you for taking the time helping me with this. It works perfect.

Hello again.
I do not know if it is possible or not to do with Excel, but thanks to your help, i am using the below formula to create a sequential number in columns, to avoid repeated rows.

Formula:
=IF(AND(G2<>"",H2<>"",I2<>"",J2<>""),"EMEA_PL_"&ROW(A1)&"-","") & CONCATENATE(G2,IF(H2="","","-"),H2,IF(I2="","","-"),I2,IF(J2="","","-"),J2)

Output:
EMEA_PL_1-NET-OS_Other-123.123.123.123-oracleacct ==> the number 1 after EMEA_PL_ will become a 2 in the next row

my question is the following, can this formula be changed to remove completely the sequential numbers and replace it by a random 4 digits number?

thanks

Try this

Please Login or Register  to view this content.

I just replaced "ROW(A1)" with "TRUNC(RAND()*9999,0)"