Results 1 to 12 of 12

Rich Text Formatting After Carriage Return

Threaded View

  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Rich Text Formatting After Carriage Return

    Hello coding experts,

    Hopefully a relatively straightforward problem. I have a list of products and descriptions setup in an excel table. I reference the product elsewhere in the workbook, and pull the description beneath it using two carriage returns, as such:

    =C4&""&INDEX(MY_TABLE_DESCRIPTION,MATCH(C4,MY_TABLE_PRODUCT,0))

    Can someone point me in the right direction for creating a loop that will format the description (text found after the carriage returns) as size 8 font? Please note that this will (hopefully) be applied to other multiple sheets.
    Last edited by Leith Ross; 06-03-2015 at 02:05 PM.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replace text string in a cell and retain rich text formatting (Excel 2013)
    By CharlieBear in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-15-2015, 04:39 PM
  2. [SOLVED] Add Carriage Return to a text string?
    By NewYears1978 in forum Excel General
    Replies: 2
    Last Post: 03-29-2014, 01:06 AM
  3. carriage return without wrap text?
    By Paul Stockdale in forum Excel General
    Replies: 2
    Last Post: 06-12-2013, 06:28 AM
  4. carriage return in a text cell
    By dockdude in forum Excel General
    Replies: 1
    Last Post: 02-25-2011, 04:12 PM
  5. Carriage Return in General Text Box?
    By Al Franz in forum Excel General
    Replies: 1
    Last Post: 01-24-2005, 05:06 PM

Tags for this Thread

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