Solved How do I BOLD specific text string in a Concatenate formula?

August 7, 2014 at 05:20:06
Specs: Windows 7
Using Excel 2010
Do not want to use VBA, if possible.
If this request is not available in 2010, is it available in 2013?

See More: How do I BOLD specific text string in a Concatenate formula?

Report •

August 7, 2014 at 09:35:39
✔ Best Answer
I do not believe that you can format individual parts of the result of a formula.

There are some workarounds that can be found via a Google search, such as strategic positioning of Text Boxes linked to cells, etc.


Insert however many text boxes you need to create the concatenated string.

One at a time, Select each text box, click in the formula bar and enter e.g. =A1 to have the result from that cell appear in the text box.

Arrange the text boxes next to each other, format them as No Line and format the text the way you want, e.g. Bold.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 7, 2014 at 09:48:36
Thanks DerbyDad.
I am familiar with the separate cell boxes and have used that in the past for small data. However, I am trying to set up a large contract with approximately 300 pages and many different data entries throughout the form. The data will change in size for every contract, so utilizing separate cells would not be efficient. Much of the data is replicated up to 20 times throughout the form, so it would require a lot of adjustment.

Ideally, the company needs to purchase an actual contract software that is designed specifically for what we are trying to do.

Report •

August 7, 2014 at 11:06:39
Is there a specific reason that you want to avoid using VBA?

Note: Even though I'm a big fan of VBA, I can also easily understand that are a number of reasons one might want to avoid using it. I'm just curious as to why you don't want to use it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

August 8, 2014 at 04:09:45
I would love to learn to use VBA and it certainly would be helpful for many of my spreadsheets. However, this specific project would be a huge undertaking and not beneficial for me or my company to try to learn VBA with.

We have several contracts, and a dozen other forms that are currently in Word format. I do not like to use WORD and my administrative staff is not skilled enough to use it or any other program.

Due to the fact that our 4.5 billion dollar a year company does not want to purchase software for contracts and all back office forms and processes, I have been seeking a way to auto-populate our contracts and forms. Our IT department will also not allow us to have a data base. So I thought I could try to prepare these documents in Excel to help out with this task. The concatenate function appears to work, but there are BOLD items and RED items in our contracts and forms.

My goal was to have a hidden sheet that all data could be entered on and then auto-populate all contracts, as well as the 10 other forms often used for each project. In this manner, the admin staff would not have to page through all of the sheets and different forms. All project data would only have to be entered once and if revised, only need to do it in one place.

Report •

August 8, 2014 at 05:45:51
They won't let you purchase turn-key contract software but they'll let you spend countless hours designing a custom built application that will have no one to support it when you hit the lottery, find a better job, or just get fed up with short-sighted management decisions.

Makes sense to me...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 8, 2014 at 08:50:31
LOL.... Now you sound like you work with us.....
Yes, exactly.
For some reason, they believe it is cheaper to pay benefits and overtime for employees that copy and paste and duplicate data entry in a dozen locations and then do it all over again when there is a revision. However, they pay fairly well, including 100% of health benefits for entire family and manage to remain very profitable.

It is apparent amongst many, that if you stay too long in this company, you become unskilled and less marketable, as the technology and industry processes evolve. Maybe that is their tactic and why there are many employees here for 7 - 30+ years.

Thanks for your suggestions.

Report •

Ask Question