Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Below is an example of a strring of data that i receive. Many times the data
string is over 255 characters in length. ( bigger that the capacity of the location that i am copying it to. Is there a way to programatically parse out those strings longer than allowed in my field I need to do that to a text string that is both comma deliminated ( item & quatity) and semicolon deliminated (Record) 262662,1;287740,1;266043,1;265832,1;283351,1;29886 4,1;292744,1;301754,1;302201,1;283346,1;296536,1;2 92910,1;274865,1;293748,1;77029,1;47952,1;295392,1 ;292327,1;273352,1;276065,1;256396,1;269669,1;2696 71,1;82205,1;301349,1;269668,1;260051,1;81462,1;26 9670,1;302623,1;281220,1;297459,1;257806,1;271241, 1 The item is not always the sam# of characters and the quantiy either Is there a way to take all text including Say (10) semicolons |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parsing a text string into separate cells | Excel Worksheet Functions | |||
seperating text in one cell to multiple cells | Excel Discussion (Misc queries) | |||
help parsing multiple text sets from one cell | Excel Worksheet Functions | |||
Seperating of Text in one cell into two columns | Excel Worksheet Functions | |||
Parsing when deliminator is a string | Excel Worksheet Functions |