Results 1 to 3 of 3

Thread: Convert Text from .txt to columns in excel

  1. #1
    Junior Member
    Join Date
    Aug 2012
    Posts
    12
    Rep Power
    0

    Convert Text from .txt to columns in excel

    Hi All,

    Looking for a macro to Open the text file from a path and convert it to text to Column in excel.
    Basically every time when i run the Macro it should ask for the path of the Text file and then convert the content to columns in the excel file.

    Thanks in advance,
    Ravi

  2. #2
    Junior Member
    Join Date
    Feb 2015
    Posts
    6
    Rep Power
    0
    Quote Originally Posted by ravichandavar View Post
    Hi All,

    Looking for a macro to Open the text file from a path and convert it to text to Column in excel.
    Basically every time when i run the Macro it should ask for the path of the Text file and then convert the content to columns in the excel file.

    Thanks in advance,
    Ravi
    Is it possible for you to share the sample txt

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Also you can record a macro while doing this manually. Post the recorded code, so that any of us can refine for you.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Replies: 1
    Last Post: 08-29-2016, 01:23 PM
  2. Convert Excel Formulas That Contain Specific Function In To Value
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 5
    Last Post: 09-28-2013, 01:53 AM
  3. VBA Macro To Convert Text To Proper Case
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 05-31-2013, 12:38 AM
  4. Xls export to txt
    By marreco in forum Excel Help
    Replies: 4
    Last Post: 12-28-2012, 10:43 PM
  5. Convert Text In YYYYMMDD Format To Date Format
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 02-28-2012, 12:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •