+ Reply to Thread
Results 1 to 2 of 2

Address Split

  1. #1
    Registered User
    Join Date
    05-03-2016
    Location
    Pune
    MS-Off Ver
    10
    Posts
    0

    Address Split

    Hi Folks,

    I'm stuck in a situation. where I need to split address string which varies from 80 chars to 300 Char in split in sub string of 80 chars max. But the catch is each sub-string should be broken down logically. If at all 81 char is not space( and is genuine Character (a,b,c) then the sub string should be broken down from the space prior 80 char.


    Example:

    Address String
    MASTERCARD INTERNATIONAL Ground floor,South Indian Bank New data center SIB Buildings, Info Park

    Expected Result:

    Address Line_1
    MASTERCARD INTERNATIONAL Ground floor,South Indian Bank New data center SIB

    AddressLine_2:
    Buildings, Info ParkExpress Highway, Rajagiri Valley, Kakkanad Ernakulam

    Request your help

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Adwait.,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split Address Using Formula
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2015, 12:10 AM
  2. [SOLVED] Split cells postcode from address
    By dsthome in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-10-2013, 02:15 AM
  3. Address split problem
    By vishal kiran in forum Excel General
    Replies: 1
    Last Post: 04-26-2013, 02:20 AM
  4. help me to split the address in one cell
    By prabhuduraraj09 in forum Excel General
    Replies: 3
    Last Post: 06-01-2012, 01:47 PM
  5. Cell Address split
    By Vic Schoeman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2011, 05:03 AM
  6. split up an address block
    By chuckjlewis in forum Excel General
    Replies: 1
    Last Post: 02-28-2008, 10:48 AM
  7. [SOLVED] Split Address Correction
    By Carleton in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-11-2006, 04:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1