| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statements - Pick up Alpha Characters
Hi,
Can anyone tell me if there is a way to pick up (using an IF statement) whether a cell has any letters in it, if a cell has letters in it I need to pick up another cell. Example of what I have: Cost Centre Ref # IF Statement Answer 1234 0012 1234 2345 0014 2345 2346 9987 2346 TED 3865 3865 ** Show Ref # as Cost Centre has Letters in it. 4678 3678 3678 Many Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find alpha all characters | Excel Discussion (Misc queries) | |||
| Ranking Alpha Characters | Excel Discussion (Misc queries) | |||
| How can I pick up characters after the first 4 in Excel cell | Excel Discussion (Misc queries) | |||
| Alpha characters problem? | Excel Worksheet Functions | |||
| Check for Alpha characters | Excel Discussion (Misc queries) | |||
Threaded Mode
