| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wildcards in formulae
Hello,
Im wondering if its possible for formulae to contain wild cards. e.g. i have a list of invoice numbers, some have LDN at the start some dont. What i would like to do is make an IF formula which will find the invoices that dont have LDN at the start. i was hoping that '=if(a1=LDN*,a1,concatenate("LDN",a1))' would work but needless to say it doesnt. What, if anything replaces that * so i can search for part entires in cells? Many thanks, Rikki |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use of wildcards | Excel Worksheet Functions | |||
| Wildcards in RTD | Excel Discussion (Misc queries) | |||
| wildcards in vba | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| VBA Wildcards - HELP! | Charts and Charting in Excel | |||
Threaded Mode
