Append word before text

[hkbhansali]

Hi,

I want to add common text to the beginning of all cells "OK" with condition
IF Text string is =17 (LEN=17) then ADD "OK" Text beginning of cell.

is that possible? if so, then how?

[jeffreybrown]

Your request is not entirely clear to me, but this will check the LEN of A1. If the LEN is = 17 then add the text "OK", if not then just return what is in A1

=IF(LEN(A1)=17,"OK "&A1,A1)

[hkbhansali]

Thanks..jeffreybrown

it's perfect what I want..

[jeffreybrown]

You are very welcome and thanks for the feedback.