Hi, another query for you guys.
I have an excel file that has data only in the first column, the data is an import from a .txt file. Unfortunately the standard delimited functions doesn't help me as each cell is of varying lengths and all I want to do is split each word in Row1 Column A into a cell per word in Column B, C, D then moving down to row 2 and doing the same thing and so on. There is a sample spreadsheet attached.
Kind thanks
Last edited by guerillaexcel; 01-17-2011 at 05:42 AM. Reason: Solved
hi, a cell per word will mean
14 JAN 2011 - all three in three different columns
COMPANY: 8 ACME Inc - all 4 in different columns
Is it what you are looking for?
Hi watersev, thats right yes.
In that case this will suffice:
Sub snb() Workbooks.Open "E:\example.txt", , , 3 End Sub
Won't this just open my spreadsheet?Originally Posted by snb
In that case this will suffice:
Sub snb() Workbooks.Open "E:\example.txt", , , 3 End Sub
Did you test it ? It converts a txt-file into a worksheet.
i did yes, apologies, that opens the txt file in excel just fine, cheers.
The next step is now splitting each cell in column A, any ideas?
That should have been done: dive into VBEditor's Help : lemma Open.
the fourth argument '3' indicates that a space is a fielddelimiter.
Close Excel and try my macro again.
Yes, very strange, it still does not delimit the cells, but it should work.
may be it suits you as an option, run macro "RE"
This works perfectly, thanks very much!
Thanks to you both for all of your help and suggestions, rep left for you.
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks