+ Reply to Thread
Results 1 to 2 of 2

copying text only with specific formating

  1. #1
    Registered User
    Join Date
    10-23-2013
    Location
    hampshire
    MS-Off Ver
    Excel 2010
    Posts
    3

    copying text only with specific formating

    i consolidate documents but at the moment I have to manually copy and paste the title into another cell to seperate it from the description to be able to consolidate. What I'd like to know is it possible to copy specifically formated text into another cell, so for example in 1 cell, I have the title and the deascription, but add no extra work to others i want that title to automatically be copied into another cell, without copying the description underneath, the title is in bold, so is it possible to only copy bold formatted text into another cell?
    Regards
    Rhys

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

    Re: copying text only with specific formating

    You can't do that with a formula.

    Pete

+ 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. copying text only with specific formula
    By rhyssmith92 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2013, 06:49 AM
  2. Conditional formating based on specific text in string in another cell
    By mraheelgujjar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2011, 01:09 PM
  3. Macro for copying specific text from a cell
    By mvel_sky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2010, 02:47 AM
  4. Copying Text Right of Specific Character
    By LevinTrueno in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-10-2008, 03:34 PM
  5. CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS
    By Twiggy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2006, 04:20 AM

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