Hello
I am wiriting a VBA macro, to consolidate text into columns. This text is pasted from a pdf file , and is entered into column A, from here I would like the macro to seperate this into columns. The realy problem I have is that i do not know how to tell the macro to seperate text and numbers, also each pdf file has slightly different lenghts of words or numbers
Example below
Any help would be brilliant!
Last edited by ben5496; 11-27-2011 at 01:25 PM.
Do you have some more samples that you can provide? I worked out the Text to columns functionality in 2007 and the 1st row worked fine. Except that the text before the date got separated into 2 columns which can be merged into 1. (ghghghghghg & ghghghghg - can be merged using =A1&B1
However, the 2nd row has a "-" which makes excel think that its a formula to subtract and gives the #VALUE error. If you can provide more samples, we can look to see if we can first have a procedure to change the "-" to some other character and then merge the data in the 2 columns and then re-input the "-". (mdmgfmgm -ffffff gets split as mdmgfmgm and -ffffff which creates the problem due to the - sign).
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Pl see attached file. macro run will do your requirement.
Any clarifications wel-come.
Last edited by kvsrinivasamurthy; 11-24-2011 at 04:20 AM.
Thank you that is brilliant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks