Let's say the content of a cell is something like this:
<tagabc</tag <tagdef</tag

And let's also say that strings "abc" and "def" are a different font than
the tags. Let's say the tags are Times New Roman while the strings between
tags are Arial.

When I do a find and replace to delete the space between "</tag <tag", the
font of my strings changes from Arial to Times New Roman.

Is there a way to prevent this from happening?

Using Excel 2003.

In the "Find and Replace" box click "Format," and you can search for a
particular format and replace it with the same format or a different one.
The entire "Format cells" menu is available when you click "Format." Even
spaces have font formats.

"Tony Logan" wrote in message
...
Let's say the content of a cell is something like this:
<tagabc</tag <tagdef</tag

And let's also say that strings "abc" and "def" are a different font than
the tags. Let's say the tags are Times New Roman while the strings between
tags are Arial.

When I do a find and replace to delete the space between "</tag <tag",
the
font of my strings changes from Arial to Times New Roman.

Is there a way to prevent this from happening?

Using Excel 2003.

Tried this but it didn't work. It still changes the font of the string
between tags as well, which I don't want to happen.

I need to be able to do the search and replace and keep the existing fonts
in the cell what they a tags in font A, and text between tags in font B.

Is there a way to do this?

Thanks.



"Richard O. Neville" wrote:

In the "Find and Replace" box click "Format," and you can search for a
particular format and replace it with the same format or a different one.
The entire "Format cells" menu is available when you click "Format." Even
spaces have font formats.

"Tony Logan" wrote in message
...
Let's say the content of a cell is something like this:
<tagabc</tag <tagdef</tag

And let's also say that strings "abc" and "def" are a different font than
the tags. Let's say the tags are Times New Roman while the strings between
tags are Arial.

When I do a find and replace to delete the space between "</tag <tag",
the
font of my strings changes from Arial to Times New Roman.

Is there a way to prevent this from happening?

Using Excel 2003.

I think you'll have to look at each character and keep track of the font (and
all the other attributes???).

You may want to try this:
http://groups.google.co.uk/group/mic...ee5401f618fd94

or
http://snipurl.com/14omr



Tony Logan wrote:

Let's say the content of a cell is something like this:
<tagabc</tag <tagdef</tag

And let's also say that strings "abc" and "def" are a different font than
the tags. Let's say the tags are Times New Roman while the strings between
tags are Arial.

When I do a find and replace to delete the space between "</tag <tag", the
font of my strings changes from Arial to Times New Roman.

Is there a way to prevent this from happening?

Using Excel 2003.

--

Dave Peterson

Gave the code referenced in the below link a whirl, but I'm getting this
error: "Cannot define a Public user-defined type within an object module".

Don't know enough VBA to be able to correct it. Any ideas?

Thanks.


"Dave Peterson" wrote:

I think you'll have to look at each character and keep track of the font (and
all the other attributes???).

You may want to try this:
http://groups.google.co.uk/group/mic...ee5401f618fd94

or
http://snipurl.com/14omr



Tony Logan wrote:

Let's say the content of a cell is something like this:
<tagabc</tag <tagdef</tag

And let's also say that strings "abc" and "def" are a different font than
the tags. Let's say the tags are Times New Roman while the strings between
tags are Arial.

When I do a find and replace to delete the space between "</tag <tag", the
font of my strings changes from Arial to Times New Roman.

Is there a way to prevent this from happening?

Using Excel 2003.

--

Dave Peterson