Results 1 to 5 of 5

How to split Text in a Cell with line break to different columns

Threaded View

  1. 06-01-2018, 10:31 AM #1
    Rev12
    Rev12 is offline
    Registered User
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    97

    How to split Text in a Cell with line break to different columns

    Hi! I have a data In my cell B2 (column name Address)

    Albany Medical College
    47 New Scotland Avenue MC70
    Albany NY, 12208
    Ph: (612) 239-6115
    Fax: (612) 239-6118
    muns@mail.amc.ed


    I want to split the City / Phone / Fax / email to different columns,

    Please any help is much appreciated.

    A sample of my spreadsheet is attached.

    I have tried the formulas from some of the threads but no luck.

    Thanks in advance.

    Rev12
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Can I distribute text across columns when my delineator is a line break?
    By Joanne Marie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2015, 05:46 AM
  2. Can I distribute data from a cell across columns when delineator is a line break?
    By Joanne Marie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-11-2015, 05:41 AM
  3. 'text to columns' or 'split' function for line of text without space, comma, etc?
    By affj in forum Excel General
    Replies: 4
    Last Post: 07-25-2013, 05:28 AM
  4. Split string by line break into array
    By kennychung in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2009, 12:18 PM
  5. break line in text cell from ASP
    By Lorenzo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2006, 09:10 AM
  6. Split text like line wrap into multi columns
    By 1scant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2006, 03:53 PM
  7. line break in a cell-Is there a way to get the line break instead of a symbol?
    By luvgreen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2005, 02:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1