I am importing a bank account statement to a workbook and everything is fine
except for one of the lodgement accounts. the problem with this is that the
name of the account is -GB Cheque. when this is imported the workbook thinks
it is a formula and put this in the cell #NAME?. when i click the cell you
can see the name in the formula box. as i have over 3000 records is there
anyway i can fix this without going through every record and deleting the =
sign.

Any help please.

Monty

You can change format of That column to text and then select column and
Replace(ctrl+H) = signe with blank

"Monty" wrote:

I am importing a bank account statement to a workbook and everything is fine
except for one of the lodgement accounts. the problem with this is that the
name of the account is -GB Cheque. when this is imported the workbook thinks
it is a formula and put this in the cell #NAME?. when i click the cell you
can see the name in the formula box. as i have over 3000 records is there
anyway i can fix this without going through every record and deleting the =
sign.

Any help please.

Monty

This error is occurring because XL thinks you are trying to create a function
and there is no function with that name.

You could create a helper column with the formula =IF(LEFT(A1,3)="-GB","GB
Cheque",A1) and then copy the values of this helper column back into column A
(or whichever other column has these values.

Dave
--
Brevity is the soul of wit.


"Monty" wrote:

I am importing a bank account statement to a workbook and everything is fine
except for one of the lodgement accounts. the problem with this is that the
name of the account is -GB Cheque. when this is imported the workbook thinks
it is a formula and put this in the cell #NAME?. when i click the cell you
can see the name in the formula box. as i have over 3000 records is there
anyway i can fix this without going through every record and deleting the =
sign.

Any help please.

Monty

If you're importing from a .txt file, maybe you can fix it when you're
importing.

Make sure you choose Text for that field.

Monty wrote:

I am importing a bank account statement to a workbook and everything is fine
except for one of the lodgement accounts. the problem with this is that the
name of the account is -GB Cheque. when this is imported the workbook thinks
it is a formula and put this in the cell #NAME?. when i click the cell you
can see the name in the formula box. as i have over 3000 records is there
anyway i can fix this without going through every record and deleting the =
sign.

Any help please.

Monty

--

Dave Peterson