+ Reply to Thread
Results 1 to 4 of 4

Separate text

  1. 05-28-2016, 03:42 PM #1
    Eazio
    Eazio is offline
    Registered User
    Join Date
    05-28-2016
    Location
    Varberg, Sweden
    MS-Off Ver
    2013
    Posts
    19

    Separate text

    Want to separate the text in two merged cells with a vinculum like in this pic I made in paint
    Namnlös.jpg
    How to? :D
    Last edited by Eazio; 05-28-2016 at 03:49 PM.
    Reply With QuoteRegister To Reply
  2. 05-28-2016, 03:50 PM #2
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Separate text

    See attached. Formulas are in D1 and D2
    Eazio Seperate Text.xlsx
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
  3. 05-28-2016, 03:53 PM #3
    Eazio
    Eazio is offline
    Registered User
    Join Date
    05-28-2016
    Location
    Varberg, Sweden
    MS-Off Ver
    2013
    Posts
    19

    Re: Separate text

    The thing is I want the line to be partial
    Reply With QuoteRegister To Reply
  4. 05-28-2016, 04:05 PM #4
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Separate text

    The only way that I know to do that is to remove the centerline border in D1 then click the U icon while D1 is selected.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How To Separate Numbers Mixed with Text in separate Colum
    By muhammad.haq1974 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2016, 07:58 PM
  2. VBA code - copy selected text, separate string text into different cells and tidy up
    By EMcK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2015, 08:52 AM
  3. [SOLVED] Excel2010 IF Formula to return value based on a separate date and two separate text values
    By jakecutler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2015, 03:24 AM
  4. [SOLVED] Separate numeric/text combination into two separate columns.
    By Jim15 in forum Excel General
    Replies: 6
    Last Post: 10-09-2013, 05:49 PM
  5. [SOLVED] Splitting text from one cell into separate text fragments, Located in adjacent cells
    By onsid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 08:32 PM
  6. How to separate numbers from text in a code (into a separate column)
    By Gooford in forum Excel General
    Replies: 10
    Last Post: 03-08-2012, 12:31 PM
  7. Separate Text into separate cells
    By Rokketman in forum Excel General
    Replies: 1
    Last Post: 09-09-2009, 09:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1