Thread: Remove Space in Cells
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Remove Space in Cells
On Mon, 31 Mar 2008 06:35:02 -0700 (PDT), wrote:

Hi Rebecca,
There is a function called TRIM. It removes all spaces from a text
except single spaces between words.
If your texts start at A1, use a blank column, eg Column B and insert
=TRIM(A1)
Copy down to the end of your text cells.
You could then select all the trimmed cells in column B, copy, select
A1, Paste Special, Values, then delete the contents of column B.
Regards - Dave.

Dave,

The TRIM function removes extraneous <space characters. I believe the OP is
concerned about an extra blank line at the bottom of a word-wrapped cell.
--ron
Reply With QuoteReply With Quote