Results 1 to 4 of 4

Need to get same length series of numbers from different columns in the same cell

Threaded View

tudorr Need to get same length... 10-02-2012, 12:34 PM
FDibbins Re: Need to get same length... 10-02-2012, 01:41 PM
tudorr Re: Need to get same length... 10-02-2012, 02:16 PM
FDibbins Re: Need to get same length... 10-02-2012, 08:30 PM
  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    A, A
    MS-Off Ver
    MS Office 2010
    Posts
    12

    Need to get same length series of numbers from different columns in the same cell

    Hello. Anyone with an idea to solve this task with a formula or a macro?

    I have this strange number data stored by columns. Each cell contains one number series of different length from 1 to 13.

    Needed results 1 , Needed results 2
    7409998765 7409998766 , 9998766567876 7409998765 9998766 9998766 7409998766 9998766 9998766567876 9998766 9998766 9998766

    I need to lookup and bring in one cell for each row only the 10 length numbers separated by space and in another cell the 13 length numbers space separated also.

    The number of columns containing data is different from row to row ( from 2 to 60)....and the rows..are thousands..

    See attach of example data.

    Thank you for any idea.

    Tudor
    Attached Files Attached Files

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