+ Reply to Thread
Results 1 to 6 of 6

Bold few texts in a sentence which has a formula

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Bold few texts in a sentence which has a formula

    Hi ,

    I am working on 2010 excel and I am trying to combine few texts and end result is my complete sentence .In that complete sentence I want one letter in bold or more tahn that.

    Cell
    A1 My
    A2 name is
    A3 Shradha

    Formula A1&A2&A3

    Sentence is “My name is Shradha “ in this sentence I want Shradha letter in bold.

    Can you please help me this .

    Thanks and regards,
    Shradha

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Bold few texts in a sentence which has a formula

    Can't apply formatting to the result of formula.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Re: Bold few texts in a sentence which has a formula

    Hi ,

    We can do this with VB code I guess .Can anyone help me I don’t have knowledge about coding.

    Thanks and regards,
    Shradha

  4. #4
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Bold few texts in a sentence which has a formula

    Can you upload a sample workbook. Thanks

  5. #5
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Re: Bold few texts in a sentence which has a formula

    I am going to use this for creating hike letters for employees

    Example : XYZ employees current CTC is XXXX and updated CTC is XXXXX .etc

    My complete letters are going to be end result of combination of differnt text by using formula in that I want few fieldsin BOLD letters I dont have any dummy files but if u can give me the coding and tell me how to edit same as per my requirments I guess that can help me . Thanks Shradha

  6. #6
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Mexico
    Posts
    200

    Re: Bold few texts in a sentence which has a formula


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Bold few texts in a sentence which has a formula
    By Shradharani in forum Excel General
    Replies: 1
    Last Post: 10-10-2013, 12:34 PM
  2. Using a formula to fill in a sentence
    By davidingilbert in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2013, 04:59 PM
  3. Create a Formula where using different texts to display a value
    By garethdurbridge in forum Excel General
    Replies: 4
    Last Post: 01-11-2010, 11:06 AM
  4. Sentence case FORMULA??
    By simjambra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2009, 08:30 AM
  5. Translate formula into a sentence
    By BTMLOCICERO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2008, 10:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1