| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String to be split
Hi,
I have the string in the Excel file where the "\abc*aa**11111_aa*125.00*125.00*0.0\ " I need to split this data from the long string stored in the cell. Sometime the above marked string is broken to next row. how do I split this in macro & to find out when it is split in the different but continuous row. Split required are Col A -111111_aa Col B -125.00 col C-125.00 Col D-0.00 Thanks & regards, yagna. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split up delimited string & insert row below | Excel Programming | |||
| Split string into seperate cells | Excel Programming | |||
| Split a string | Excel Programming | |||
| Using Split Function on String with no spaces | Excel Programming | |||
| how to split a string and return array | Excel Programming | |||
Threaded Mode
