Concatenate And Bold

Nov 10, 2008

I have a simple concatenate in Excel...

=CONCATENATE(A1, ", ", A2)

Which produces:

This is, my text

Now, I want 'my text' i.e. the contents of A2 to be in bold.

I've played with the TEXT() function before, as per this page:
[url]

To get Excel to play nicely with date formats and stuff, however, my research has come to a dead end with Bold/Italic - with everyone suggesting that VBA is the only solution.

As I don't feel overly comfortable using VBA is there any other solution? (If not, is this a VBA 101 task or an advanced task?)

ADVERTISEMENT

Excel 2007 :: Concatenate And Bold

Nov 10, 2008

I have a simple concatenate in Excel...

=CONCATENATE(A1, ", ", A2)

Which produces:

This is, my text

Now, I want 'my text' i.e. the contents of A2 to be in bold.

I've played with the TEXT() function before, as per this page: [URL] ........

View 9 Replies View Related

Merging Cols Changes Bold To Non-bold Or Non-bold To Bold

Jun 8, 2008

I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular.

What I want is...

This is for service plan B: Take all data and transer to new server.

What I am getting is...

This is for service plan B:Take all data and transer to new server.

OR

This is for service plan B:Take all data and transer to new server.

View 9 Replies View Related

How To Run Macro If Selection Is Not Bold And If Bold Then Do Nothing

Aug 5, 2012

How do we run a macro if the selection is not bold and If bold then do nothing.

View 3 Replies View Related

Make 1 Cell Bold If Another 1 Is Bold

Oct 2, 2007

I am trying to create a macro that if a value in a cell in column A is bold, then the value in the same row in column H is bold, then loop it to run on the rest of the worksheet.

View 9 Replies View Related

Delete All Text Which Is Not 'bold' In Cells With 'mingled Bold' Text

Jan 23, 2010

I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.

View 4 Replies View Related

Concatenate Duplicates: Concatenate Results Of All Equal P/N's From Any Given List

Oct 6, 2007

I have a list of P/N's that are used in more then one location. and it's sorted by P/N's.

ColA__ColB__ColC
______Loc___PN
______1_____A
______2_____A
______3_____B
______4_____C
______5_____C

I Want to be able to put in Col A the concatenate results of all equal P/N's from any given list. Or at least select the few cells that i know are duplicates and from that copy the Location to a single Column.

ColA ColB__ColC
______Loc__PN
1,2____1___A
_______2___A
_______3___B
4,5____4___C
_______5___C

View 5 Replies View Related

Concatenate Non Blank Cells But Use Concatenate And Substitute Instead Of IF

Aug 11, 2013

Sampling table :

one
two
three
four
one
two
three
one
two
one

Desired results obtained via IF =IF(B2>0,A2&" , ",A2)&IF(C2>0,B2&" , ",B2)&IF(D2>0,C2&" , ",C2)&IF(D2>0,D2,"")

one , two , three , four
one , two , three
one , two
one

Is there any smarter, shorter formula via Concatenate and Substitute or other formulas ?

My closest match, but not good enaugh is =SUBSTITUTE(CONCATENATE(A2&", "&B2&", "&C2&", "&D2), ", , ", " ")
[ returna 2 commad ]
one, two, three, four
one, two, three,
one, two
one ,

View 9 Replies View Related

Set Last Row To Bold?

Sep 1, 2013

I am trying to use VBA code to set the last row to bold. I have been able to set the entire row to bold using:

Code:
EntireRow.Font.Bold = True

but I would like for the code to be more dynamic. I.E. Only making cells on the last row Bold If they contain values. I have been able to do something similar in the past with interior color on the header row but, am looking for the same type of thing for the last row in this instance. The code I was able to use to turn the interior color of cells Green looked like this:

Code:
Range("A1", Cells(1, Columns.Count).End(xlToRight)).SpecialCells(xlCellTypeConstants).Interior.ColorIndex = 3

View 3 Replies View Related

Sort By Bold

May 21, 2007

I need to sort by cells that are bold. Does anybody know a way I can do this?

View 10 Replies View Related

Last Day Of Month Bold

Sep 6, 2007

Col. A are dates,I would like to format Cells so the last day of the month is bold useing conditional fomating

View 9 Replies View Related

IF (A1 Font = Bold, A1+A2)

Dec 2, 2008

how to create an if statement based on font properties.

I did a couple searches on "conditional formatting" but didn't find anything, and it seems like the only way would be through a macro, am i correct? I'd much rather be able to do this on a formula sheet if possible.

View 9 Replies View Related

VBA Code To Bold Row Which Contains SUM

Jul 27, 2009

I'm new to VBA and needed help with:
I need to 'bold' the row which contains sum, the problem is that the location of the row varies depending on how long/short the report is....
Here is the code I used to bold a particular row:

Range("A14").EntireRow.Font.Bold = True

But instead of A14, i need it to be a row of no more than 5 columns, one of which contains the word 'SUM'.

View 9 Replies View Related

Bold Cell To Right If Cell Bold

Nov 28, 2006

i am trying to write a small piece of vba

basically if the cell in column "0" is bold then bold colum "o"
and "m" this must loop to last data row of colum "O"

View 9 Replies View Related

Find And Bold

Jun 21, 2007

Instead of bolding only the cells with an asterick in them it will bold every cell with text in it. I also would like to adapt this code to only search through column A but have not been able to figure it out.

Sub FindIt()
Dim c As Range, firstaddress As String, ws As Worksheet, FindMe As String
FindMe = "*"
For Each ws In ThisWorkbook.Worksheets
With ws.UsedRange
Set c = .Find(FindMe, LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
c.Font.bold = True
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstaddress
End If
End With
Next ws
End Sub

View 5 Replies View Related

Count Only Bold Entries

Apr 21, 2007

is there any way to get a formula to count only the entries that are in bold abd ignore all others

View 9 Replies View Related

VBA Bold Selection Code

Oct 9, 2008

i'm using the following code to make a selection bold or not (basically as a replacement for the bold button). It works fine unless you select a group of cells...some of which are already bold and some of which are not...in this case it doesn't work....here is the code

View 2 Replies View Related

Bold Row If Column A Equal To Certain Value?

Mar 11, 2013

The following code doesn't seem to work for me except when I use an actual number.

Set MR = Range("A1:A100")
For Each cell In MR
If cell.Value = "*3L*" Then cell.EntireRow.Font.Bold = True
Next

I am attempting to bold the entire row if the macro finds text that begins with 3L in a tab. If I change the code to look for a number, then it works fine.

Also - Is there a way to make this run on specified tabs? For instance, if I have four tabs:

January
February
March
Q1

Say I only want it to run on the January, March, and Q1 tab, how would I go about doing that?

View 2 Replies View Related

Counting Bold Cells

Apr 10, 2007

in the Score column I want a 3 for the SnAkEs team and 7 for the dj2 team. How do I total up the bold cells?

View 9 Replies View Related

Find A String And Bold The Row

Oct 15, 2008

I am using ctrl+f to find a string that may or may not be in a worksheet.

If it is found, i need to bold the row.

If it is not found, i need to go on to the next instruction in the macro.

I just don't know quite how to combine the If/Then with Find.

View 9 Replies View Related

Checkbox, Bold, Toggle

Jul 2, 2005

I'm having a problem making my font bold when I click on my checkbox and when I uncheck it I want the font to become unbold. I can make it bold when its checked but am not able to make it return to normal when i uncheck it..

View 9 Replies View Related

Determine If A Cell Is Bold Or Not

Jun 27, 2006

I'm trying to create a VBA module that will update data. However, I need it to skip any updates to data that has been set by the user. For simplicity, the user changes will be bold. I've found the info on the site for a function for counting cells in a range that are bold. But really just need to know how to get format of the cell.

View 4 Replies View Related

Whole Row Of Active Cell Should Be Bold

Apr 13, 2007

The text of the active cell's row should be displayed BOLD. In other words, My cursor is on row 8, then this whole row should be bold. Is this possible ?

View 5 Replies View Related

Bold Unbold Output

Apr 16, 2007

im trying to write a function and i want output to be bold when integers are outputed i did it like

Range("years").Cells(j).Font.Bold =periods

which is fine but i want to clear cells each time program is run so i used

range("x").clearcontents

, but this only deletes the values, so my question is how to delete boldness as well? i tried using IF then false function but it didnt do the job. This is what i tried to use

For j = i To def_frq * i

periods = j / def_frq
If periods = i Then Range("years").Cells(j).Font.Bold = periods Else Range("years").Cells(j) = periods

If periods <> i And Range("years").Cells(j).Font.Bold = periods = True Then Range("years").Cells(j).Font.unbold = periods Else Range("years").Cells(j) = periods

Basically I use it to split year into however many periods so it will give me fractions of the year ,but i want to select in bold when it is the whole year.

View 9 Replies View Related

Sumif With Bold Condition

Jun 1, 2007

As a starter in VBA i have a lot of doubts... one of them is, how can i sum in a column the cells that are bold? i've thought that sumif was the trick, but i don't find the way to be able to adapt code.

View 2 Replies View Related

Paste Values In Bold

Oct 4, 2007

Need line of code that can be used or modified such that one copy cell values and have them pasted in Bold?

View 3 Replies View Related

Compare & Bold Matches

Feb 16, 2008

2 worksheets,
Sheet 1 columns A&B are the same as sheet 2 A&B.

Sheet 1 is my master list (customer name = column A and carrier name = column B)

Sheet 2 (customer name = column A and carrier name = column B)

Sheet 2 is where data gets dumped so I need to change font to bold when I click a check box on sheet 1 (master list) on Column C

Check box is on column C and column C will have more then one check box.

When I click check box on C I need date to populate on column D
(But when I re-open my workbook I don't want dates to change on me using the system date)

My objective is to select customer carriers on my master list sheet 1 and update date and change font to bold on sheet 2 so I can avoid or skip that customer carrier.

Hope this is not too much for my first post.

View 3 Replies View Related

Bold Repeated String In Cell?

Aug 29, 2012

I am trying to write some code that will look in an excel cell find if it contains the word that I am looking for and make it bold. I have written the following code so far

VB:
With Worksheets("Label Print").Cells(i, J)
.Characters(Start:=InStr(.Value, "Name"), Length:=Len("Name")).Font.Bold = True
End With
[COLOR=#3E3E3E][B][/B][/COLOR]

The issue is that if "Name" occurs twice (or more) in a cell it will highlight only the first.

View 1 Replies View Related

How To Change The Last 16 Characters Of A Cell To Bold

Sep 12, 2013

I want to change the last 16 characters of a cell to bold and font color.

I have this code but doesn't work. make it a working one.

VB:

Private Sub CommandButton1_Click()
Dim ctrRight As String
ctrRight = Right(Sheets("Planning").Range("B35").Value, 16)
MsgBox ctrRight
Right(Sheets("Planning").Range("B35").Value, 16).Font.Color = RGB(51, 153, 102)
Sheets("Planning").Range("B35").Font.Bold = True
End Sub

View 4 Replies View Related

Possible To Make A Word In Formula Bold?

Jul 2, 2006

I am trying to make a word within a formula bold.

The word doesn't have to be bolded depending on the result. It will either appear or not based on the result of the formula. But obviously, if it appears, it [should] be bolded...

Obviously you can't format text on the formula bar. This is something I've wanted to do in Excel for YEARS!

View 10 Replies View Related

BOLD - Contents Of Cells In 2003

Nov 12, 2008

I cannot "BOLD" the contents of cells in my spreadsheet by clicking "B" on the menu bar. However I can do so by clicking on "Format - Cell - Font" and then using the selecting the Bold option. I wonder why this happens.

View 2 Replies View Related

Split Rows By Bold Text?

Oct 7, 2013

I have an Excel sheet with 2 columns : Date and TextColumn

The TextColumn column contains in each cell text such as this :

Title1
TextLine1
TextLine2
Title2
TextLine3
TextLine4
....

I need to split each line as follows : Each title (in bold and on a new line) and the text who follows should be placed in a new row, copying the date in each new row created.

View 1 Replies View Related

VBA Bold Specific Text In String

Jan 28, 2014

I'm using the code snippet below to add text and apply formatting to a cell within a given sheet.

[Code] .....

I'm now trying to amend this so, the word "All" is in bold text and I've recorded the a macro, and have the following:

[Code] ....

The problem is, is that when I try to amalgamate the two, I'm unable to get this to work.

View 8 Replies View Related

Bold And Unbold Text Macro

Apr 25, 2008

i'm trying to write a macro that does the same thing as the bold button. Click once and the text is bold, click again and it un-bolds.

View 14 Replies View Related

Syntax For Bold&Red Marked Line

Jan 27, 2009

Below is a part of my code. But I am getting error on the bold&Red marked line.

View 2 Replies View Related

Bold, Underline And Italic Greyed Out

May 8, 2009

My spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????

View 4 Replies View Related

Make A Cell Font Bold

Jul 30, 2009

I have the following code that I am using for a header row of an excel sheet

View 3 Replies View Related

BOLD And UNDERLINE Concatenated Cells

Apr 23, 2006

I need bolding and underlining cells that are "Concatenated". For example, cell format for cell K12 is already bolded and underlined. If I concatenate (C1,K12,D2) I get a result that doesn't carry over the format of those individual cells - particularly K12 which I want BOLDED and UNDERLINED.

View 9 Replies View Related

How To Make Certain Text In Comment Bold

May 25, 2009

I need to figure out how to make certain text bold in a comment using vba. I'm making it so it adds a comment that looks like this:

View 7 Replies View Related

Bold Selected Text In A Cell?

Sep 16, 2012

I'm trying to use the below vba code that was provided by another member. The code show work to bold any text that is found matching the text string provided.

Problem I'm having is that I get a 'Type mismatch' error when the code tries to run, as below:

Public Function Colorandbold()
'USE-COLOR AND BOLD TEXT STRINGS WITHIN TEXT EXCEL VBA
'BROUGHT TO YOU BY WWW.PROGRAMMINGLIBRARY.COM
'CREATED BY MARK SLOBODA

[Code].....

View 4 Replies View Related

Bold Specific Text In A Cell

May 22, 2014

I am trying to bold specific text in a cell. I have found some language that will do this trick to a point. In addition to the word "Foxwood" I would like to bold 9 other specific words in 5 different sheets in this workbook. Is there a way to do this without the cumbersome task of repeating this language 5 times for the different sheets and 9 times for the additional words?

Dim startPos As Integer
Dim totalLen As Integer
Dim searchText As String
searchText = "Foxwood"
For Each cl In Sheets("Week1").Range("c3:c100")

[Code] ....

View 5 Replies View Related

ADVERTISEMENT