Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

2 Answers

What function can make a text/string BOLD?

Sample data:
A1: How to use
A2: Microsoft Excel.

I want A3 to be a formula combining A1 & A2 but with A2 in BOLD letters.
example:
A3: =A1 & bold(A2)

The result that i want it to produce is:

"How to use Microsoft Excel."

(where Microsoft Excel is in Bold Letters)
thanks.

Posted by raph316 on

  • raph316 Oct 28, 2008

    i can't make it to produce the result that i wanted. doing the format cell, font-bold makes all of the contents Bold and not only the words that i wanted.

  • Anonymous May 07, 2009

    same I want only make bold a specific text within the string in the cell but I cant... how?

×

Ad

2 Answers

reroute1991

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    New Friend:

    An expert that has 1 follower.

    Greenhorn:

    A rookie expert who has answered 20 questions on their first day.

  • Contributor
  • 52 Answers

I cant be 100% sure but the way spreadsheets work, you cant have two different fonts in 1 cell. they can kind of be thought of as having a "bold=true or false" kind of attribute. it can be either on or off but it cant be both

Posted on Oct 23, 2012

Ad

Anonymous

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 52 Answers

Hi,
Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.
I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.
Glad to be of assistance - please rate the posting - I can learn from you.

Posted on Oct 26, 2008

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Insert a calculated field named % Change in Value to determine the percent change in values by type in Excel?

If field A1 is the old value and A2 is the new value, then the formula for A3 (% change) is:=(A2-A1)/A1*100You can remove the *100 if you want to format the field to the Percent type.
1helpful
2answers

What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
2helpful
2answers

I want to write an Excel IF statement using only mathematical operators (in another application). The Excel formulation is: ...

Let say you have table like this
' A ' B
---'--------------'-----------
1 ' First ' 2
2 ' Second ' 1
3 ' Third ' 3
On Cell C1 or other cell you like, try to type this formula
=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))



That's all, just IF and math operand

11_16_2012_10_24_08_am.png
0helpful
2answers

Need to have a certain cell say OFF when it is a certain day

Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.
0helpful
1answer

Excel Formula

With data in A1 to C1: A2 =IF(A1>0,1,0) B2 =IF(B1>0,1,0) C2 =IF(C1>0,1,0) A3 =SUM(A2:C2)
1helpful
2answers

School Truancy Report Formula

For the same exemple you can try this:
=COUNTIF(A1:A4,"=George Washington School")
1helpful
1answer

What is data series in microsoft excel

The data series the the string of data you would like to have included in a formula or charted on a graph. For example, if you have data in cells A1, A2, and A3 and would like this data to be included in your formula or chart, it would be designated as A1:A3, translated as A1 through A3. This can most easily be accomplished by highlighting the data when the software is asking for the data series.
0helpful
1answer

Excel Formulas!

Does the search formula help?
0helpful
2answers

Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)
0helpful
2answers

Formular to show number and cell references

The formula for A1 is: =SUM(B4,B5)
A2 is: =SUM(C4,C5)
A3 is: =SUM(A1:A2)


To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.
Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

6,992 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Brad Brown

Level 3 Expert

18689 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...