Results 1 to 15 of 15

Concatenate 2 columns

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2011
    Location
    Austin, texas
    MS-Off Ver
    Excel 2003
    Posts
    26

    Concatenate 2 columns

    Please see attached xls file.

    We need to concatenate Columns E (Route) and F (Segment Number) into Column M (ROUTESEG)

    As you will see in Column L (RouteSegxxx) the tenth decimal place (.0) does not carry over into the solution.

    Column M (ROUTESEG) needs to be to the tenth place (.0)
    i.e. 100-101.0
    100-102.0
    100-103.0
    etc.

    using =CONCATENATE(E2,"-",F2) does not result in (.0)s

    Any help with this would be greatly appreciated!

    this tenth place (.0) designation is a requirement when doing "Join" functions in ArcGIS software.
    Attached Files Attached Files
    Last edited by sirgeo; 05-03-2011 at 06:10 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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