hi
use this formula in B1 cell.putting value in a1 cell.
=IF(ISERROR(FIND("-",A1)),A1,CONCATENATE("-",SUBSTITUTE(A1,"-","")))
On 8/4/09, Putta Madaiah wrote:
>
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against Original Value.
>
> *Origi
Select all cell which u want to remove Total Charge then
do Ctrl+H ,write " total charge" in find row and in replace it with ("
")blank.
On 5/12/09, subs wrote:
>
>
> hi
>
> i have data like this in the column of the excel table
>
> total charge: apl total charge:ppg total
