+ Reply to Thread
Results 1 to 5 of 5

Separating text values in one column, plus using italics as a delemiter.

  1. #1
    Registered User
    Join Date
    03-17-2021
    Location
    Boston
    MS-Off Ver
    Current
    Posts
    3

    Separating text values in one column, plus using italics as a delemiter.

    Hi there,

    I've seen similar things solved in other threads, but I have no idea how to tweak/adapt the macros to suit the exact problem that I am currently dealing with. Hoping that one of you smart peeps can lend me a hand!

    I have this column with data values all in a row, with each item in a separate cell: name, hometown, and major. I am trying to manipulate the data so that I end up with three different columns for the three values. Of course, I would like the corresponding name, hometown and major to all be in a row. The issue that I've encountered that makes this really difficult with traditional formulas is that a decent amount of the people have multiple majors (typically 2 if they have multiple). Therefore, the pattern of 3 cells in a row having the correct, corresponding info is quickly broken. The only thing that distinguishes the majors is italics formatting, so I'm hoping that can be used as a delimeter of some sort in VBA.

    I will be eternally grateful for some insight here! Very lost as of now. I've attached a sample workbook below.

    Thanks a ton,

    Will
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    361

    Re: Separating text values in one column, plus using italics as a delemiter.

    The example has the visible italic look but the cell is not set to italic until you click into the cell
    that way its not posible to check for italic because its not set

    open your sample an select one of the botom majors in a column look then at the lint to see if italic is set
    its not
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    03-17-2021
    Location
    Boston
    MS-Off Ver
    Current
    Posts
    3

    Re: Separating text values in one column, plus using italics as a delemiter.

    Shooooot. You're absolutely correct. I got this from ABBYY fine reader. It OCRd a PDF for me. That must be why.

    Thanks anyway. I'm just going at it manually right now. I don't really have any ideas on how else this could be done. If you have any insights, I would greatly appreciate it. Sorry for missing that they weren't actually italicized.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,495

    Re: Separating text values in one column, plus using italics as a delemiter.

    This seemed to work. Except for Jaeun Cabelle Alin has the city split in two rows. I'm not sure how to fix that one.

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 03-17-2021 at 06:33 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  5. #5
    Registered User
    Join Date
    03-17-2021
    Location
    Boston
    MS-Off Ver
    Current
    Posts
    3

    Re: Separating text values in one column, plus using italics as a delemiter.

    AlphaFrog--

    You're the best! This saved me hours and hours. I really do appreciate it. Wish I could buy you a beer!

    Thanks a ton,

    Will

+ 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. Separating Bold, Italics and Underlined text
    By PaulBollard in forum Excel General
    Replies: 3
    Last Post: 01-06-2017, 10:28 AM
  2. Data cleanup: separating values in a column
    By ikaros in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2015, 11:16 AM
  3. Replies: 5
    Last Post: 08-21-2013, 10:45 AM
  4. Separating text from field with appending values
    By Jimbo42 in forum Excel General
    Replies: 4
    Last Post: 05-26-2011, 07:45 AM
  5. Merge two column with text separating two value
    By mdbdesign in forum Excel General
    Replies: 3
    Last Post: 10-08-2010, 09:24 AM
  6. separating text and numbers in a column
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2009, 04:09 AM
  7. Separating text and data in a column
    By Amber in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2006, 06:45 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