Closed Thread
Results 1 to 2 of 2

Split text into columns - formula only, no vba or excel Text to Columns

  1. 02-15-2022, 06:32 PM #1
    CRJ42
    CRJ42 is offline
    Registered User
    Join Date
    01-13-2016
    Location
    Grafton
    MS-Off Ver
    2013 Office Pro
    Posts
    59

    Split text into columns - formula only, no vba or excel Text to Columns

    I need a series of formulas to convert a single line of text into 4 columns.

    1927 S Apple Valley Rd., Madison, WI, 34561

    Convert To:

    Column A2
    1927 S Apple Valley Rd.

    Column B2
    Madison

    Column C2
    WI

    Column D2
    34561
    Reply With QuoteRegister To Reply
  2. 02-15-2022, 06:35 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Split text into columns - formula only, no vba or excel Text to Columns

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...o-columns.html
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed 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. Split text into columns - formula only, no vba or excel Text to Columns
    By CRJ42 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 02-17-2022, 04:51 PM
  2. [SOLVED] Need to split text into columns with a formula
    By Mendonk in forum Excel General
    Replies: 11
    Last Post: 11-03-2021, 08:51 AM
  3. Split cell contents by comma with formula *Can't use text to columns*
    By DannyJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2017, 06:47 AM
  4. Split data by delimiters but by formula (not Text to Columns)
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2016, 05:44 AM
  5. Formula(s) to Split Text String Across Columns Using Columns as Seperator
    By WaylettChris in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2016, 01:13 PM
  6. Using 'Text to columns' when value to split is derived from a formula
    By Aysha in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2014, 06:49 AM
  7. split text into more columns excel
    By ibarrera in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2006, 12:00 PM

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