text function question

B

benny

Hi all,
Hopefully my confuse is not so difficult to help.
I have text arrays in column A2:A100 (much datas) which are filled with "n"
and such as "loose end", "soft". I want in the column A1 is containing the
text excludes "n".
Due to of my poor function knowledge i tried to use CONCATENATE function but
this is too long ..what should i use the proper formula.

txs in advance 4 any helps
 
Top