Home/ Questions/Q 3866
Next
Answered
computing
  • 3
Asked: 2021-11-04T23:18:15+00:00 In:

Excel: Some Cells In Sheet Won’t Center When Directed To

  • 3

Some of my cells will not respond when I apply centering, either with the centering icon or the Format Cells; Alignment; Horizontal Center. Other cells in the same sheet act normally.

Share

    1 Answer

    1. Best Answer
      Are you importing this data from outside Excel?

      Make sure there aren’t any stray space characters or other unprintable stuff.

      You can use the =TRIM() and =CLEAN() functions to strip out all unwanted characters.

      Something like =CLEAN(TRIM(A1))

      MIKE

      http://www.skeptic.com/

      • 0