Results 1 to 6 of 6

Splitting textstring (adress) into seperate columns

Threaded View

  1. 06-02-2014, 08:20 AM #1
    soli004
    soli004 is offline
    Registered User
    Join Date
    08-11-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    93

    Splitting textstring (adress) into seperate columns

    Hello forum!

    I have address that sits in one cell only and I need to separate into two or three columns (streetname, street number, streetletter).

    Is this possible as the length of street text, numbers and letter differs all the time...

    Attached is a sample file with before and after result

    Thanks
    Attached Files Attached Files
    Last edited by soli004; 06-02-2014 at 01:01 PM.
    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. Splitting rows with multiple columns into seperate rows for time points.
    By mbracha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2013, 10:06 AM
  2. Splitting Information in columns into seperate rows
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-19-2010, 06:15 PM
  3. Splitting First Name & Family Name Into Seperate Columns
    By hagadol in forum Excel General
    Replies: 1
    Last Post: 11-07-2009, 10:09 AM
  4. Splitting Date & Time into two seperate columns
    By mccrimmon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2008, 08:42 AM
  5. How to adress columns
    By adiman84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2008, 03:18 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