I hope this isn't hijacking...but it is a question about a possible answer to the question posed.
If "I have a " is in A1 and "Dog." is in B1...could you not have VBA code that you could initiate after you select C1 that would identify the string length of A1 and B1 seperately, combine the two texts together - plugging it into the active cell (c1) and then using the known originating string lengths change the formatting of just part of the resulting string? (BTW...I live for RUN-ON questions=)
Im still new to VBA...but I swear my brain is IBM...
Bookmarks