Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing empty spaces
I have a colum of data that has spaced before the text...the number of spaces
varies per cell.. how do i eliminate the spaces within each cell? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing empty spaces
With Range("A1:A12")
.Offset(, 1).Value = Application.Trim(.Value) End With Regards, Peter T "dstiefe" wrote in message ... I have a colum of data that has spaced before the text...the number of spaces varies per cell.. how do i eliminate the spaces within each cell? Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing empty spaces
If you want to get rid of all the space characters, you could:
Select the range to fix edit|replace what: (space character) with: (leave blank) replace all don't do this if the cells contain other spaces that need to be kept. dstiefe wrote: I have a colum of data that has spaced before the text...the number of spaces varies per cell.. how do i eliminate the spaces within each cell? Thank you -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing empty spaces
See if =TRIM(A1) and pull down does what you want.
HTH Regards, Howard "dstiefe" wrote in message ... I have a colum of data that has spaced before the text...the number of spaces varies per cell.. how do i eliminate the spaces within each cell? Thank you |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing empty spaces
use TRIM function. e.g. if your data is in column A, you could put formula
in b1: =TRIM(A1) and copy down the length of your data. removes both leading and trailing spaces. "dstiefe" wrote: I have a colum of data that has spaced before the text...the number of spaces varies per cell.. how do i eliminate the spaces within each cell? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to eliminate empty spaces ? | Excel Discussion (Misc queries) | |||
Delete empty spaces at the end of text of a column? | Excel Programming | |||
killing empty spaces in unusall fashion .. | New Users to Excel | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |