| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula needed... regular expression?
A1 contains "TC_1 and TC_2 are really cool TC_5 and TC_6, but TC_7 is better"
B1 should use a formula to generate "TC_1, TC_2, TC_5, TC_6, TC_7" There are 550 rows, so the formula should be flexible enough to apply to "N" number of matches, and insert the matches into column B corresponding to the entry in column A of the same row. A2 contains "TC_1 and TC_22 are really cool TC_5" B2 should use a formula to generate "TC_1, TC_22, TC_5" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regular Expression | Excel Discussion (Misc queries) | |||
| Counting Expression in a Single formula | Excel Worksheet Functions | |||
| Excel expression {=SUm(if(istext(c8:k8),1,0))} | Excel Worksheet Functions | |||
| > and < criteria in one single expression in excel | New Users to Excel | |||
| Excel Expression | Excel Discussion (Misc queries) | |||
Threaded Mode
