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
HansVogelaar
Nov 15, 2021MVP
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)