Results 1 to 5 of 5

Macro to convert the text in to string?

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2010
    Location
    Akron,OH, USA
    MS-Off Ver
    Excel 2007
    Posts
    44

    Question Macro to convert the text in to string?

    I have a text file with lines. All I want to do is convert line text into number. I want to declare them as array.and output them in different cells in worksheet.
    Example:
    if one of the text line is-

    Text input:
    C39000779710904010000053000000003100004000000000000002000000000000016

    Excel output:
    A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1 Q1 R1 S1
    C 39 000779 7 1 09 04 01 00 00053 00000 00031 00004 00000 00000 00002 00000 00000 00016
    (1 2 6 1 1 2 2 2 2 5 5 5 5 5 5 5 5 5 5) -> Length on the numbers
    the text file has several lines. So there should be a loop to go through the end of file.
    Please help me.
    Last edited by mithil; 11-02-2010 at 08: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