| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF Function for column containing text - Excel 2007
I have a Column of pricing from a csv. file that has TBA in some rows (price
to be announced). I would like to change TBA to a 0. I have started with =IF(E1="TBA", ??? I also have a coded price column for cost price and would like to get rid of the letter code and also change remaining price to a 2 decimal cost. I've been reading and trying all kinds of things. I really need an IF function for the first column and am not sure what I need for the second. Any help really appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Text Box | Excel Discussion (Misc queries) | |||
| Column Header Excel 2007 | Excel Discussion (Misc queries) | |||
| Text to Column Function Rejects Zeros | New Users to Excel | |||
| Function to move text 65 characters to next row in column? | Excel Worksheet Functions | |||
| Looking for a Function which counts the repeatition of text in a column | Excel Worksheet Functions | |||
Threaded Mode
