Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello. I have a column where the each cell consists
strings like, column ---------------- 12 3/4 2-7 3b 8/n L45 I have alot of such cells possible more than 10000 cells in the column. Now i want to separate each string untill not finding a numeric. For example, for the above cells, i want to have two such columns: columns1 columns2 --------------- --------------- 12 3 /4 2 -7 3 b 8 /n L45 How can i do such a thing? Thanks lot. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
Create a formula into a String then assign string to a cell | Excel Programming |