Preserve Formatting

[david.fielding@virgin.net]

Thanks in advance is there any way to preserve formating when
concantenating strings for example

example one

"example" would be aerial font and "one" would be times new roman font,
italic bold for instance

If it is not possible with a formula what about a worksheet function or
a macro

Cheers
David

[Bernard Liengme]

No
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<david.fielding@virgin.net> wrote in message
news:1120495250.991892.20700@g44g2000cwa.googlegroups.com...
> Thanks in advance is there any way to preserve formating when
> concantenating strings for example
>
> example one
>
> "example" would be aerial font and "one" would be times new roman font,
> italic bold for instance
>
> If it is not possible with a formula what about a worksheet function or
> a macro
>
> Cheers
> David
>

[david.fielding@virgin.net]

Yes

[David McRitchie]

Hi David (Fielding),
I don't think so, but you can try searching newsgroups:

Coloring Capital Letters within a cell, posting by Mike Currie, 2002-12-19,
http://groups.google.com/groups?thre...0@TK2MSFTNGP12
in excel.misc, colors capitals Red [3], non-capitals as black [lowercase and digits with 1] and error cells with Teal [14] using a
Change Event macro, I included a comparable ColorCapsCatchUp macro for use on existing cells prior to installing the Change Event
macro. You can search Google Groups for the string Characters(Start:= for additional examples of formatting or coloring
parts of text strings.

But the you would have to find something that determines the color of each character,
so if it can be done with a macro under specific circumstances -- known
input and output cells you still have to indentify the color of each character
of your input and I don't recall any posting to that effect.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<david.fielding@virgin.net> wrote in message news:1120648175.591396.105570@f14g2000cwb.googlegroups.com...
> Yes
>

[david.fielding@virgin.net]

Thanks David (McRitchie),

I done this using a worksheet function in the end

Cheers
David

[David McRitchie]

Hi David,
How did you manage to concatenate and preserve two different
fonts using a (builtin) worksheet function. i.e. Arial in from one cell
and Times New Roman bold italic from another cell.

Can you please tell use exactly what you did.
---
David McRitchie, Microsoft MVP - Excel

<david.fielding@virgin.net> wrote in message...
> I did this using a worksheet function in the end

[david.fielding@virgin.net]

Hello David (McRitchie),
I should of been more accurate I used a custom worksheet function

Cheers
David

PS Is there a way of knowing when someone has replied to a post, I
didn't know there was a follow up question I just happened to be
looking around and saw the follow up question

Thanks

[David McRitchie]

Hi David,
can you be very specific about what you did for the formatting.

I rarely reply from Google Groups, so I don't know how the
Google interface goes for reading Microsoft newsgroups without
doing a search.

You can search on your name by using your email address
author:xyz@xyx.com

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<david.fielding@virgin.net> wrote in message news:1122546243.827406.105960@f14g2000cwb.googlegroups.com...
> Hello David (McRitchie),
> I should of been more accurate I used a custom worksheet function
>
> Cheers
> David
>
> PS Is there a way of knowing when someone has replied to a post, I
> didn't know there was a follow up question I just happened to be
> looking around and saw the follow up question
>
> Thanks
>