Keystroke for edit

  • Thread starter Thread starter EddieZ
  • Start date Start date
E

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
 
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
 
Back
Top