Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
George
 
Posts: n/a
Default How do I delete spaces from the end of text

Some of the text fields that I have to clean up have a space (or more than
one space). I need to clean this text up so the last word is the end of the
text string.

Any ideas?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How do I delete spaces from the end of text

Id the text copied from the web, in that case you might have trailing html
characters, if not us

=TRIM(A1)

otherwise

=TRIM(SUBSTITUTE(A1,CHAR(160),""))

if there are many see:


http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--

Regards,

Peo Sjoblom


"George" wrote in message
...
Some of the text fields that I have to clean up have a space (or more than
one space). I need to clean this text up so the last word is the end of

the
text string.

Any ideas?

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.misc
George
 
Posts: n/a
Default How do I delete spaces from the end of text

Very helpful. Thanks again.

"Peo Sjoblom" wrote:

Id the text copied from the web, in that case you might have trailing html
characters, if not us

=TRIM(A1)

otherwise

=TRIM(SUBSTITUTE(A1,CHAR(160),""))

if there are many see:


http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--

Regards,

Peo Sjoblom


"George" wrote in message
...
Some of the text fields that I have to clean up have a space (or more than
one space). I need to clean this text up so the last word is the end of

the
text string.

Any ideas?

Thanks




  #4   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default How do I delete spaces from the end of text


Hi, have a look at the TRIM function.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493960

  #5   Report Post  
Posted to microsoft.public.excel.misc
vee vee is offline
external usenet poster
 
Posts: 12
Default How do I delete spaces from the end of text


What if the space appears to be at the front?? I copied some data, and i
have to go cell-by-cell and delete out the first space (but there doesnt seem
to be a space) to make a formula work that is referring to that cell??

Thanks! Veronica

"pinmaster" wrote:


Hi, have a look at the TRIM function.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493960


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete empty rows between rows with text Paulo Baptista Excel Discussion (Misc queries) 2 February 28th 05 04:41 PM
Macro to delete and replace a text box Dave Excel Discussion (Misc queries) 0 February 24th 05 06:17 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 08:22 PM
Macro to delete a text box and copy in new one Dave Excel Discussion (Misc queries) 1 February 18th 05 03:02 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM


All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"