+ Reply to Thread
Results 1 to 2 of 2

COncatenate Number and ;

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    Neverland
    MS-Off Ver
    2007
    Posts
    9

    COncatenate Number and ;

    guys i have alist of numbers around 10000 i wanna make them in a row with ";" between each numbers any ideas?

    7583;1904;1781

    7583
    1904
    1781
    8146
    6950
    6847
    1793
    4464
    1636
    1043
    6823
    8254
    1799
    7821
    1800
    7613
    7509
    6604
    8147
    6374
    3602
    6711
    6496
    3037
    7522
    3409
    1785
    7485
    8046
    8140
    7249

  2. #2
    Registered User
    Join Date
    01-05-2012
    Location
    Neverland
    MS-Off Ver
    2007
    Posts
    9

    Re: COncatenate Number and ;

    got it, first =CONCATENATE(A1,";") then i i pasted it with paste special made it transpose

+ Reply to Thread

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