+ Reply to Thread
Results 1 to 2 of 2

Capture the Address info from web and Parse it according to address details

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    19

    Capture the Address info from web and Parse it according to address details

    Hi Forum,

    Here is my requirement,

    I have address details like this

    ABC Limited
    #5, XYZ Tower, 2nd Cross,
    ABC 1st Stage, RRR Nagar, KA
    pppp - 110012
    IN

    I need to copy this info from web and paste in Excel by splitting into respective address fields

    Expected Results

    Name Address City State Postal Code Country
    ABC Limited #5, XYZ Tower, 2nd Cross, pppp KA 110012 IN


    -Nanju
    Last edited by Nanjunda; 10-14-2014 at 07:00 AM.

  2. #2
    Forum Contributor
    Join Date
    08-04-2014
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    579

    Re: Capture the Address info from web and Parse it according to address details

    Depending on the amount of data you have to process, this might not be useful.

    If your data is in rows like in the example it will be pasted into excel also in rows, which means you can use the TRANSPOSE function to transform it into columns.

    Lets assume your data is in range A1:A5

    Select your column range and use this formula =TRANSPOSE(A1:A5) then push Shift+Ctrl+Enter without exiting the formula and the data from the rows will be transformed into columns.

+ 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. Get name details from Global Address List
    By adyteo in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2013, 05:45 AM
  2. Parse Email address from middle of a string
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2011, 09:17 PM
  3. print box to be filled in with address details
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2010, 08:20 PM
  4. Capture Email Name Or Address
    By JoJo in forum Excel General
    Replies: 2
    Last Post: 03-20-2007, 02:47 PM
  5. Use VBA to capture IP address
    By KR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1