TRIM FUNCTION

TRIM FUNCTION

Post by big smil » Sat, 01 Oct 2011 20:54:08



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.xls
23K Download
 
 
 

TRIM FUNCTION

Post by dguillett » Sat, 01 Oct 2011 22:12:42


      =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:
1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

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


<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 
 
 

TRIM FUNCTION

Post by rajan verm » Sun, 02 Oct 2011 15:51:54


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:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 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


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 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


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

--
Regards
Rajan verma
+91 9158998701
 
 
 

1. Using the trim function with VBA

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

2. NETWARE & UNIXWARE

3. Trim function

4. Chaining devices with cd-reWriter

5. Workstation Shares

6. Using Watcom DB trim() function in embedded sql

7. Trap in OS2KRNL (14.089a UNI)

8. trim function

9. Glass break trim rings

10. Audio Level trim

11. Trim plates with wall switch (WS467)