| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String to name
How to convert the value to name where
IF(K2=CONCATENATE("label",a2,"_start"), "OK","Failed") name value 1) label20_start 2) label30_start 3) label40_start 4) label50_start 5) .... a2 is a cell where cell a2 value = 20 cell a3 value = 30 cell a4 value = 40 cell a5 value = 50 ...... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
![crapit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
