Split String into Cells with incased values 
Ive got a tricky problem that hopefully someone has the answer too....
I am currently getting data in the following format...
[ ] [ 1.00]  [Item 1] [1 ] [ 0]
[ ] [ 2.00]  [Item 2] [2 ] [ 0]
[ ] [ 3.00]  [Item 3] [3 ] [ 0]
[ ] [ 4.00]  [Item 4] [4 ] [ 1000]
[ ] [ 5.00]  [Item 2] [5 ] [ 0]
Im currently having to rewrite it when i get it which is crazy time consuming..
If i paste it into excel it goes into 5 cells.. A1 : A5 ... one on each line which is cool.... so id like to be able to extract all the data out of between the [ ] 's
B1 would = Blank (since there is no data in it...)
C1 would = 1.00
D1 would = 001
Does anyone know of a way of doing this.. ive spent time looking through google etc but im struggling to come up with a solution...
Thanks in advance...
May by Using the MID function. Like for example:
Data starts in column A1 in
and drag to copy the formula down.
This will work if the format of data are the same: Example attached.
The values between the 's (brackets) will vary sometimes.....
Im wondering if i deleted all the opening [ and delimited based on the ]
that might work.... then the values between them would not need to be consistant...
Cheers for the advice though.... thats a good thought.. but i just dont think it will work in this case...
ok. no worries.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1