YasserKhalil
Well-Known Member
Hello everyone
I have in Range("B2:B" & LastRow) some data which looks like that
some text some data < Text 1|4 >
The same structure for all the cells in that range
I need that part < Text 1|4 > to be of Arial font type only but to keep the remainder of the cell with the old font type ...is it possible?
Note: the data is over 10,000 rows
The main thread is on this link
http://www.excelforum.com/showthread.php?t=1134479&p=4362617
But not the same request so as not to be cross poster
I have in Range("B2:B" & LastRow) some data which looks like that
some text some data < Text 1|4 >
The same structure for all the cells in that range
I need that part < Text 1|4 > to be of Arial font type only but to keep the remainder of the cell with the old font type ...is it possible?
Note: the data is over 10,000 rows
The main thread is on this link
http://www.excelforum.com/showthread.php?t=1134479&p=4362617
But not the same request so as not to be cross poster