Results 1 to 5 of 5

Concatenate address lines of varying number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2011
    Location
    Chester, England
    MS-Off Ver
    Excel 2013
    Posts
    117

    Concatenate address lines of varying number

    I am trying to concatenate lines of addresses.

    There are two problems:
    1. The first line could start in a different row each time
    2. The number of lines varies

    I have sorted the first issue by matching the line that says 'Address', then offsetting by one row.

    I have a formula to determine the number of lines by subtracting the last row of address from the first row (the cell after the last line contains the text "Customer contact details").

    In this instance, I could use nested if statements for every permutation, but is there a better way?

    Thanks in advance.
    Attached Files Attached Files
    Last edited by tone640; 08-08-2011 at 09:50 AM.

Thread Information

Users Browsing this Thread

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

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