G
Garrystone
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
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