Forum Discussion

RONB1234's avatar
RONB1234
Copper Contributor
Nov 15, 2021

excel function TO know if my text is aligned LEFT

excel function TO know if my text is aligned LEFT

1 Reply

  • RONB1234 

    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)

Resources