+ Reply to Thread
Results 1 to 4 of 4

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 than 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.

    I read in Google that formatting in excel with formula is possible only with VB code .Can you please help me with this .I am not much aware of VB coding other than editing those as per requiremnt with some audience.

    Thanks and regards,
    Shradha

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

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

    It cannot be done using a formula.

    Pete

  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...

    Is that can be done with VB code ??

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

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

    Yes. It can be done.

    Take a look to this Thread. You'll find an excellent code by Mike.

    http://www.excelforum.com/excel-form...ont-color.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. Bold few texts in a sentence which has a formula
    By Shradharani in forum Excel General
    Replies: 5
    Last Post: 10-11-2013, 03:56 PM
  2. [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
  3. 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
  4. 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
  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