[Solved] Add suffix in excel for conditional list [closed]

by


Create a row or column next to your data, depending on how it’s laid out, and use:

=IF(AND(LEFT(A1,1) = "(",  RIGHT(A1,1) <> ")"),CONCAT(A1,")"),A1)

Where A1 is your first cell of data you wish to manipulate, then drag down or across for all valid cells.

2

solved Add suffix in excel for conditional list [closed]