Hi Everybody

I have a spreadsheet that imports data from CSV file and although I can use the deliminate when importing, it does not work for all the values inported. For instance, some entries act as one word and are entered in the same cell ("AA") where in fact there should be two cells adjacent to each other with "A" in them both. It may also import showing A(A) where one cell should be A and the other (A).
I have tried the following formula below, and although it does copy the correct part of the text into the adjacent cell, it will still leave the first cell unaltered and hence I need to edit that cell and remove the text (and before that special paste the adjacent cells because of the formulas).
=IF(OR(A1="AA",A1="A(A)"),IF(A1="AA","A",IF(A1="A( A)","(A)")),"")

I am sure there is an easier automated way of achieving this, can anyone help?

Thank you

Garry