#1
|
|||
|
|||
Formating Partial cells in a large list
I am trying to format a 13k list of cells with one command if possible. Each cell will have data but I only want to bold certain words in that cell.
Example: A1 John, Mary, William B1 Robert, James, Mary C1 Mary, John, Paul In this example I would like to bold Mary each time in a long list I would like to carry that format down the column 13k+ times. Is there a command that can do this |
#2
|
||||
|
||||
I doubt there is a native command for this or that it can be done with a formula.
There are many VBA solutions on the net, though. Cheers
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Can you share the location some of these VBA solutions? Thank you
|
#4
|
||||
|
||||
I don't mean to be rude but you can find that by yourself, don't you?
Search for ' formatting part of a string in a cell" or something approaching
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Large Word doc duplicating large sections when I print it. | Kea | Word | 3 | 05-30-2015 02:28 PM |
Partial downloads | stusk | Outlook | 0 | 10-04-2014 02:20 AM |
Chart Formating with ChartTitle Font and DataLabel Formating | shilabrow | Excel Programming | 0 | 06-30-2014 10:01 AM |
Formating cells in a Row | mbesspiata | Excel | 6 | 06-27-2014 08:12 AM |
Excel 07 formating 17 cells "Need Formula" | Raner | Excel | 2 | 05-30-2010 02:07 PM |