Thanks DP again.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Mon, Aug 26, 2013 at 4:46 PM
Subject: Re: Fwd: $$Excel-Macros$$ Extra Space Enter to be removed from a
cell
To: excel-macros@googlegroups.com
=TRIM(SUBSTITUTE(C2,*CHAR(10)*, ))
SUBSTITUTE
Hello,
Can I get help from you to remove extra space / enter from column C in
the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
try this formula
=TRIM(SUBSTITUTE(C2,CHAR(10), ))
Pada 26/08/2013 17:33, Pravin Gunjal menulis:
Hello,
Can I get help from you to remove extra space / enter from column C
in the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space Enter
...@premor.net mailto:d...@premor.net
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space Enter to be removed from a
cell
To: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com
try this formula
=TRIM(SUBSTITUTE(C2,CHAR(10), ))
Pada 26/08/2013 17:33