Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim function
i am using a formula
in c1 if(a1="a","***","") sometimes the formula fails in subsequent rows i suspect that there is a blank space following the "a" how would one incorporate the trim function within the if statement or do you have to use a helper column to trim and then evaluate the trimmed result thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim function
Hi,
Use =if(trim(a1)="a","***","") Regards Govind. wrote: i am using a formula in c1 if(a1="a","***","") sometimes the formula fails in subsequent rows i suspect that there is a blank space following the "a" how would one incorporate the trim function within the if statement or do you have to use a helper column to trim and then evaluate the trimmed result thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim function
if(trim(a1)="a","***",""). --Bruce
" wrote: i am using a formula in c1 if(a1="a","***","") sometimes the formula fails in subsequent rows i suspect that there is a blank space following the "a" how would one incorporate the trim function within the if statement or do you have to use a helper column to trim and then evaluate the trimmed result thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trim function
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim Function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |