replace first character of cell content

**Armitage2k** · 09-26-2009, 06:15 AM

Hello!

I am using a macro to copy, sort, format and delete some data which I pull from a textfile. however, some data (text only) starts with a "-" sometimes which was originally thought to help sort the data in the system from where the data originally comes from. Now when I import the columns to excel, I have the problem that excel understands the "-" as a formula and echoes me a #NAME error for that cell, which causes the macro to stop while processing it and leaves unfinished.

So, could someone maybe please provide me some code which helps me to check all cells in a certain range if any is starting with a "-" and if yes, replaces it with a " ' " or something else which is acceptable for excel?

thank you very much for the help!
A2k

**Shijesh Kumar** · 09-26-2009, 06:34 AM

Add this code at the end of ur macros

Please Login or Register  to view this content.

**Armitage2k** · 09-26-2009, 07:01 AM

well, i do know about the search and replace function (and actually have this in use at the moment) but the data also has several "-" later in the cell content, which I dont really like to replace. It would have to be strictly the FIRST character of the cell content which should be replaced.

Thanks,
A2k

**Shijesh Kumar** · 09-26-2009, 07:21 AM

Originally Posted by Armitage2k

well, i do know about the search and replace function (and actually have this in use at the moment) but the data also has several "-" later in the cell content, which I dont really like to replace. It would have to be strictly the FIRST character of the cell content which should be replaced.

Thanks,
A2k

Actually the above code is replacing the - when it is the first character .. see what := "=-" so, it is not just finding - but it is finding =- ( equal and hyphen combination)