Bold specific words in cell

[AlexShip]

Hey guys,

I have a query which I hope someone can address.

I have the following formula in cell A1.

=CONCATENATE("Here's the quote to import your goods from ",B2)

It currently it looks like this:

Here's the quote to import your goods from London

But I want it to look like this:

Here's the quote to import your goods from London

If someone can tell me if this is possible that would be great.

[CK76]

You can't bold part of formula result. Even with VBA. Excel isn't the best tool for string manipulation.

EDIT: There are workarounds, but is going to result in messy set up and isn't recommended. One example is to over-lay TextBox or other object on top of text to make it appear bolded.

[AlexShip]

Thank you for your prompt response.

Is there a way to use macros?

Edit: I would essentially like to copy and paste this formatted data into an email

[xladept]

You can do it all with code:

Please Login or Register  to view this content.

[AlexShip]

Thanks for the code.

I have just used that on an example document and it works!!

[AlexShip]

On the basis I use the formula below:

=CONCATENATE("Here's the quote to import your goods from FOB ",F2," ","(FOB Explained) to you in ",F3,", ","UK")&CHAR(10)&CONCATENATE("- ",F4," ","carton(s), totalling ",F5,"cbm ","and weighing ",F6,"kg")&CHAR(10)&CONCATENATE("- Sea Freight from FOB ",F2," ","and delivered to you - ", A5)

It would look like this:

Here's the quote to import your goods from FOB Shanghai (FOB Explained) to you in London, UK
- 2 carton(s), totaling 1cbm and weighing 1kg
- Sea Freight from FOB Shanghai and delivered to you - £1000 + UK Duty & VAT*

How would I have it so that it looks like this:

Here's the quote to import your goods from FOB Shanghai (FOB Explained) to you in London, UK
- 2 carton(s), totaling 1cbm and weighing 1kg
- Sea Freight from FOB Shanghai and delivered to you - £1000 + UK Duty & VAT*

[xladept]

You can still do it with code:

Please Login or Register  to view this content.

[AlexShip]

That's excellent. Certainly, appreciate all the help!!

[xladept]

You're welcome!

BTW - you could have all those added ranges "bolded" if you wanted!