Forum Discussion
RONB1234
Nov 15, 2021Copper Contributor
excel function TO know if my text is aligned LEFT
excel function TO know if my text is aligned LEFT
1 Reply
You could create a custom VBA function:
Function HAlignment(rng As Range) If IsNull(rng.HorizontalAlignment) Then HAlignment = "Undetermined" Else Select Case rng.HorizontalAlignment Case xlHAlignLeft HAlignment = "Left" Case xlHAlignCenter, xlHAlignCenterAcrossSelection HAlignment = "Center" Case xlHAlignRight HAlignment = "Right" Case xlHAlignGeneral If IsNumeric(rng.Value) Or IsDate(rng.Value) Then HAlignment = "Right" ElseIf WorksheetFunction.IsText(rng.Value) Then HAlignment = "Left" Else HAlignment = "Center" End If Case Else HAlignment = "Distributed/Justify/Fill" End Select End If End Function
Use like this:
=HAlignment(A2)