Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2016, 07:46 AM
Zajac Zajac is offline Formating Partial cells in a large list Windows 10 Formating Partial cells in a large list Office 2013
Novice
Formating Partial cells in a large list
 
Join Date: Aug 2016
Posts: 2
Zajac is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-16-2016, 08:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formating Partial cells in a large list Windows 7 64bit Formating Partial cells in a large list Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 08-16-2016, 08:39 AM
Zajac Zajac is offline Formating Partial cells in a large list Windows 10 Formating Partial cells in a large list Office 2013
Novice
Formating Partial cells in a large list
 
Join Date: Aug 2016
Posts: 2
Zajac is on a distinguished road
Default

Can you share the location some of these VBA solutions? Thank you
Reply With Quote
  #4  
Old 08-16-2016, 09:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formating Partial cells in a large list Windows 7 64bit Formating Partial cells in a large list Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,771
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating Partial cells in a large list 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 Partial cells in a large list Formating cells in a Row mbesspiata Excel 6 06-27-2014 08:12 AM
Formating Partial cells in a large list Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft