## TRIM FUNCTION

### 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 the same cell to trimed as look as --- 25989599vvv  [ i want to
remove the space in between]

is it possible with excel function.

Thanks

### TRIM FUNCTION

=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 the same cell to trimed as look as --- 25989599vvv  [ i want to
remove the space in between]

is it possible with excel function.

Thanks

--
----------------------------------------------------------------------------------
Some important links for excel users:

3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

<><><><><><><><><><><><><><><><><><><><><><>

### TRIM FUNCTION

Hi,
if you dont want to use Function then Replace the Space.

>     =SUBSTITUTE(F9," ","")

> *Sent:* Friday, September 30, 2011 6:54 AM

> *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 the same cell to trimed as look as --- 25989599vvv  [ i want to
> remove the space in between]

> is it possible with excel function.

> Thanks

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

> <><><><><><><><><><><><><><><><><><><><><><>

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

> <><><><><><><><><><><><><><><><><><><><><><>

--
Regards
Rajan verma
+91 9158998701

I have a spreadsheet with text in cells A16:A400 (roughly).  What I
want to do is run a vba macro that runs through that data and TRIMS
all of the text in that range.  I'm sure there is an easy way to do
this, but haven't played around with enough.  Any suggestions?
Thanks...

Paul