Bold specific alphanumeric text...

[Dan10]

I need a macro which will bold specific alphanumeric text. The text always starts with a capital T, G, H or W and is always followed by either a one, two or three digit numeric value with no spaces. The text is variably in one or more cells in one or two columns. Any help with this would be much appreciated.

 

[JvdV]

You probably want to look into regular expressions to use a pattern to find each substring of interest in a cell. You can then loop over each submatch, find the starting position, it's length and use the Range.Characters() property to Bold the Font at specific indices.

 

[Peter_SSs]

The text is variably in one or more cells in one or two columns.

That is a bit vague. Could you give us a smallish set of sample data with XL2BB and explain again in relation to that specific sample data?

 

[Dan10]

That is a bit vague. Could you give us a smallish set of sample data with XL2BB and explain again in relation to that specific sample data?

Thank you.