Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default How set a format on one of more strings in a concatination

Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 - is it
possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default How set a format on one of more strings in a concatination

You can't in a formula. You will need to convert to a string and then you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 - is
it
possible?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default How set a format on one of more strings in a concatination

Any chance that you know how to do the task with converting it to a string
and make the headline bold?

"Don Guillett" wrote:

You can't in a formula. You will need to convert to a string and then you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 - is
it
possible?




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default How set a format on one of more strings in a concatination


if it is a string like
xxxxyyyyzzzz
then just place your cursor in the FORMULA BOX and highlight what you want
to change. This can be done with a macro using

Characters Property
See Also Applies To Example Specifics
Returns a Characters object that represents a range of characters within the
object text. You can use the Characters object to format characters within a
text string.

expression.Characters(Start, Length)

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Any chance that you know how to do the task with converting it to a string
and make the headline bold?

"Don Guillett" wrote:

You can't in a formula. You will need to convert to a string and then you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 -
is
it
possible?






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 104
Default How set a format on one of more strings in a concatination

Thanks Don, but I am sorry to say but I don't fully understand what you are
writing concerning using the Characters Property, could you please give an
example?

A B C
HeadLine1 Decription1 HeadLine+Desc1 C1= (BOLD(A1)&char(10)&B1
HeadLine2 Decription2 HeadLine+Desc2 C2= (BOLD(A2)&char(10)&B2
HeadLine3 Decription3 HeadLine+Desc3 C3= (BOLD(A3)&char(10)&B3
....


"Don Guillett" wrote:


if it is a string like
xxxxyyyyzzzz
then just place your cursor in the FORMULA BOX and highlight what you want
to change. This can be done with a macro using

Characters Property
See Also Applies To Example Specifics
Returns a Characters object that represents a range of characters within the
object text. You can use the Characters object to format characters within a
text string.

expression.Characters(Start, Length)

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Any chance that you know how to do the task with converting it to a string
and make the headline bold?

"Don Guillett" wrote:

You can't in a formula. You will need to convert to a string and then you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 -
is
it
possible?








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default How set a format on one of more strings in a concatination

I thought I said that it must first be converted to a string before you can
bold part manually or with a macro using the characters property. I did give
an example or you may, as I did, goto the vba help index and type in
characters


--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Thanks Don, but I am sorry to say but I don't fully understand what you
are
writing concerning using the Characters Property, could you please give an
example?

A B C
HeadLine1 Decription1 HeadLine+Desc1 C1=
(BOLD(A1)&char(10)&B1
HeadLine2 Decription2 HeadLine+Desc2 C2=
(BOLD(A2)&char(10)&B2
HeadLine3 Decription3 HeadLine+Desc3 C3=
(BOLD(A3)&char(10)&B3
...


"Don Guillett" wrote:


if it is a string like
xxxxyyyyzzzz
then just place your cursor in the FORMULA BOX and highlight what you
want
to change. This can be done with a macro using

Characters Property
See Also Applies To Example Specifics
Returns a Characters object that represents a range of characters within
the
object text. You can use the Characters object to format characters
within a
text string.

expression.Characters(Start, Length)

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Any chance that you know how to do the task with converting it to a
string
and make the headline bold?

"Don Guillett" wrote:

You can't in a formula. You will need to convert to a string and then
you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in
C1 -
is
it
possible?








  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How set a format on one of more strings in a concatination

Steen

Example only.

Sub CellFont()
With ActiveCell.Characters(Start:=1, length:=5).Font
.ColorIndex = 3
.Bold = True
.Underline = True
.Size = 14
End With
With ActiveCell.Characters(Start:=6, length:=3).Font
.Superscript = True
.ColorIndex = 5
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 02:03:07 -0800, Steen
wrote:

Thanks Don, but I am sorry to say but I don't fully understand what you are
writing concerning using the Characters Property, could you please give an
example?

A B C
HeadLine1 Decription1 HeadLine+Desc1 C1= (BOLD(A1)&char(10)&B1
HeadLine2 Decription2 HeadLine+Desc2 C2= (BOLD(A2)&char(10)&B2
HeadLine3 Decription3 HeadLine+Desc3 C3= (BOLD(A3)&char(10)&B3
...


"Don Guillett" wrote:


if it is a string like
xxxxyyyyzzzz
then just place your cursor in the FORMULA BOX and highlight what you want
to change. This can be done with a macro using

Characters Property
See Also Applies To Example Specifics
Returns a Characters object that represents a range of characters within the
object text. You can use the Characters object to format characters within a
text string.

expression.Characters(Start, Length)

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Any chance that you know how to do the task with converting it to a string
and make the headline bold?

"Don Guillett" wrote:

You can't in a formula. You will need to convert to a string and then you
can bold part of it.

--
Don Guillett
SalesAid Software

"Steen" wrote in message
...
Hi
Can anyone help me with the following problem:

A B C
HeadLine Description Bold(Headline)
Description

I have found the first part of the solution elsewere on the site:
C1 = A1 & Char(10) & B1

But how do I set the Headline in Bold and not the description in C1 -
is
it
possible?







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditonal Format with a date format Kevin Excel Discussion (Misc queries) 2 April 27th 05 10:20 PM
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM
why does currency format change to number format? Cassie Excel Discussion (Misc queries) 3 March 18th 05 07:57 PM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 11:03 AM


All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"