| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reorganize string
I have a string, such as "msl=30mk/kg". I want to reorganize it to "30
(msl)". but the troubles are that the digits of number (30) is not stable, this time 30, that time 40.89, maybe next time whatever it want to be. Besides, the unit "mk/kg" is not stable, either. till now, I have wrotten the following function. but the troubles listed upon can't be solved yet. who can help me? =MID(A1,FIND("=",A1,1)+1,2) & " (" & MID(A1,1,FIND("=",A1,1)-1) & ")" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reorganize Data | Excel Discussion (Misc queries) | |||
| Reorganize Excel Options | Setting up and Configuration of Excel | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Reorganize list | Excel Discussion (Misc queries) | |||
Threaded Mode
