+ Reply to Thread
Results 1 to 4 of 4

Separating Bold, Italics and Underlined text

  1. #1
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    Excel 2212 Build 15928.20216
    Posts
    36

    Separating Bold, Italics and Underlined text

    Hi, I was wondering if anyone could help me,

    The version I use is Microsoft Excel Starter 2010 (Microsoft Office version 14.0).

    Here's my query:

    In my excel document, the only column I am using is "Column A". It is filled with approximately 20,000 names.
    A small percentage of these names are in bold text (perhaps 10%), a small percentage are in Italics (perhaps 5%) and a small percentage are in underlined text (perhaps 25%).
    What I want to do is separate the data by putting all the Bold, Italics and Underlined text into "Column B".

    Any help would be greatly appreciated.

    Thanks, Paul.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Separating Bold, Italics and Underlined text

    Sorry! Removed reply just realized VBA not available in starter edition and I was using that as a possible solution.

    DBY
    Last edited by DBY; 01-04-2017 at 12:45 PM.

  3. #3
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    Excel 2212 Build 15928.20216
    Posts
    36

    Re: Separating Bold, Italics and Underlined text

    No problem, thanks for trying to help me anyway.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Separating Bold, Italics and Underlined text

    Welcome to Excel Forum.
    Was the formatting (Bold, underlined etc.) of the text assigned by conditional formatting rules? If so then uploading a small desensitized spreadsheet that shows the conditional formatting applied would help us to help you.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Exact comparison including bold / italics / underline
    By qjawaid in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-30-2014, 07:28 PM
  2. Populated cell does not copy font style (italics, bold, etc)
    By ten10thmuse in forum Excel General
    Replies: 3
    Last Post: 01-29-2014, 04:55 PM
  3. Extracting underlined text
    By THaas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2013, 06:21 PM
  4. Bold and underlined subtotals
    By dbrault in forum Excel General
    Replies: 0
    Last Post: 01-25-2013, 09:42 AM
  5. Separating Bold from After-Bold Parts of Cell Strings
    By mlexcelhelpforum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2012, 07:11 AM
  6. Finding Bold, Italic text mixed in a cell & separating them
    By toomuchGuinness in forum Excel General
    Replies: 0
    Last Post: 08-26-2011, 10:51 AM
  7. Replies: 2
    Last Post: 02-28-2008, 01:45 PM
  8. bold italics or underline
    By Dorothy in forum Excel General
    Replies: 5
    Last Post: 02-16-2005, 11:28 AM

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