Hi,
if you dont want to use Function then Replace the Space.
On Fri, Sep 30, 2011 at 6:42 PM, dguillett1 wrote:
> =SUBSTITUTE(F9," ","")
>
> *From:* big smile
> *Sent:* Friday, September 30, 2011 6:54 AM
> *To:* EXCEL MACRO GROUP
> *Su
=SUBSTITUTE(F9," ","")
From: big smile
Sent: Friday, September 30, 2011 6:54 AM
To: EXCEL MACRO GROUP
Subject: $$Excel-Macros$$ TRIM FUNCTION
Respcted Sir & group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want
Respcted Sir & group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as look as --- 25989599vvv [ i want to
remove the space in between]
is it possible with excel function.
Thanks
--
---
