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
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space & Enter to be removed from
=TRIM(SUBSTITUTE(C2,*CHAR(10)*," "))
SUBSTITUTE is to replace somestring, in our case we need to replace
ENTER Char(enter Char in ASCII Code is 10) to meet your requirement with
a single space to make it a single line, Then because there is soo many
space there, and you want to remove it, we
Thanks DP again.
-- Forwarded message --
From: De Premor
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