If you first format a cell as Text you can enter a string with @ as the first
character.

If you start your string with a single quote (apostrophe) the first "real"
character can be @
--
Gary''s Student - gsnu200817


"GeraldM" wrote:

I am importing text into a range of cells then processing it using a VBA
macro to replace particular characters.

However if the imported text starts with the @ character the replacement
routine does not process that cell or subsequent cells.

In this instance, because I control the exported data, I have simply added a
"Space" character before the @ symbol prior to exporting.

However this may not always be an option.

Does anyone have any suggestions on how to force the replace function to
treat the @ symbol as a normal character?

Regards GeraldM