Forum Discussion
Solved
How to remove spaces at the end of a cell on a multi-row column
07:30 - 15:30 (00) 15:30 - 00:00 (00) 00:00 - 07:45 (210) 00:00 - 07:30 (210) 00:00 - 07:30 (00) 22:45 - 07:15 (00) 07:30 - 22:00 (00) 06:00 - 06:34 (00) 07:15 - 07...
Thank you Hans
I think it is another problem. I will use the IF funktion, but it dosn´t work. I have som output from another program (Lessor Workforce) and I would like to compare thise to colums, I kan see in column C there is different gaps. If I change it, the IF function is still not working. I need a sheet who tells me if there are different hours in columns C and D. Can You see what the problem is?
Here is a macro. Select the range before running it.
Sub RemoveSpaces()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Selection
c.Value = Trim(Replace(c.Value, Chr(160), ""))
Next c
Application.ScreenUpdating = True
End Sub