Keystroke for edit

[EddieZ]

Is there a keystroke that starts editing at the beginning
of the text in a cell? I have alot of cells with text
starting with 4 blank spaces and I am trying to create a
macro to delete them.

Thank You!

EZ

 

[MikeLewis]

Have you tried the =Trim function? It will remove all
leading spaces

 

[popgroove]

I think you are looking for the Trim() function......

Here's one of many ways to achieve what you're asking:

Public Sub Remove4Spaces()
Application.ActiveCell = Trim(Application.ActiveCell)
End Sub

Then assign a shortcut to the macro to get your "Keystroke" to remov
blank spaces from a cell.

Mark Wielgus
www.AutomateExcel.co

 

[EddieZ]

Thank You. Works great.

EZ

-----Original Message-----
Have you tried the =Trim function? It will remove all
leading spaces
.

 

[EddieZ]

Thank You. Works great.

EZ