| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If it's not a space, return the cell contents.
I have a column of data that's generated when some tests are done.
There are "File" names, then any number of "Page" names. All the Page names start with 5 spaces (space-bar hits). I would like an if/then function that would look at the first character and if it's not a space to return the contents of the cell. Like if the cell says " A23 " I would get a return of "" (nothing). If the cell says "BC55HTM" I would get a return of "BC55HTM" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Don't allow a space in a cell...how to prevent? | Excel Discussion (Misc queries) | |||
| Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
| How do I clear the contents of one cell from another cell? | Excel Worksheet Functions | |||
| return a blank cell | Excel Worksheet Functions | |||
Threaded Mode
