+ Reply to Thread
Results 1 to 6 of 6

convert text to columns but after specific sign

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    convert text to columns but after specific sign

    Hi everyone!

    I have a bit of a conundrum. I am trying to separate this column with the help of Data - Text to columns - Fixed width but seperate it after ")" and there doesn't seem to be an option for that.

    Does anyone know a trick how to achieve that? I have attached the file.

    I'd be overjoyed is someone could help me out

    Konnie
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: convert text to columns but after specific sign

    You don't use fixed width for that, you use "delimited" and put a bracket in the "other" box.

    You might have to TRIM the output if there are leading spaces.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: convert text to columns but after specific sign

    use formula
    for 1st phrase use:
    =LEFT(A2;FIND(")";A2))

    for the 2nd phrase use:
    =MID(A2;FIND(")";A2)+2;LEN(A2))

  4. #4
    Registered User
    Join Date
    11-20-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: convert text to columns but after specific sign

    Guys you are brilliant! Thank you both so much for you help and you input!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: convert text to columns but after specific sign

    You're welcome. Thanks for the rep.

  6. #6
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: convert text to columns but after specific sign

    Hi Konnie,

    I suppose, this cannot be achived by fixed width however you may want to consider delimited option.
    Please my attachment that will explain you better.

    Let me know if this solves your problem.

    Regards,
    Kiran
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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