$$Excel-Macros$$ Please help to apply formula

2010-02-08 Thread $ⓤⓗⓐ$
Hi all, How to apply more than two functions in a singal formual., For ex:- i have to *concatenate* data and make it *trim *and *proper.* Appreciate your soonest response. Thank you all. -- Suhas -- -- Some imp

Re: $$Excel-Macros$$ Please help to apply formula

2010-02-08 Thread $ⓤⓗⓐ$
&TRIM(C2) > > Next, the Proper() function expects a string, then use the output from the > previous > function: > =PROPER(TRIM(A2&" "&B2&" "&C2)) > or: > =PROPER(TRIM(A2)&" "&TRIM(B2)&" "&TRIM(