Need to bold last name in directory-possible in formula?

lburg801

New Member
Joined
Oct 25, 2005
Messages
14
Here is the formula. There are singles, couples shareing same last name, and couples with different last names. In the formula G is the ;ast name and need to be in bold, before mail merege. Is there a way for this to be done?

=IF(ISBLANK(J2),G2&", "&F2,IF(J2=G2,G2&", "&F2&" and "&I2,J2&", "&G2&" and "&I2&" "&J2))

Thank you,
Trudy
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,270
Sorry, individual character formatting for values returned by formulas, while the cell contains the formula, is not possible. The returned value would need to be a constant (such as being copied and pasted over as a value) for your request to be do-able.
 

lburg801

New Member
Joined
Oct 25, 2005
Messages
14
Tom Urtis said:
Sorry, individual character formatting for values returned by formulas, while the cell contains the formula, is not possible. The returned value would need to be a constant (such as being copied and pasted over as a value) for your request to be do-able.

Thank you. Alas, I shall struggle on, always knowing that the greatest part of my problem is that I know very little about what I am doing! :confused:
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
The simple solution is to put the last name in a cell by itself and the rest of the formula result in the adjacent cell. Bold the first cell and format the 2 to look like a single cell.

lburg801 said:
Tom Urtis said:
Sorry, individual character formatting for values returned by formulas, while the cell contains the formula, is not possible. The returned value would need to be a constant (such as being copied and pasted over as a value) for your request to be do-able.

Thank you. Alas, I shall struggle on, always knowing that the greatest part of my problem is that I know very little about what I am doing! :confused:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,628
Messages
5,832,762
Members
430,165
Latest member
Idjaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top