excel left pad spaces

AlgoRhythm answered on September 22, 2021 Popularity 4/10 Helpfulness 2/10

answer excel left pad spaces

related excel right pad spaces

Comment

= REPT( " " , [target-length] - LEN( [cell-ref] ) ) & [cell-ref]
Example: =REPT(" ",12-LEN(B5))&B5

Popularity 4/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: excel pad spaces whatever

Link to this answer
Share Copy Link

Contributed on Sep 25 2021

AlgoRhythm

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

= [cell-ref] & REPT( " " , [target-length] - LEN( [cell-ref] ) )
Example: =B5&REPT(" ",12-LEN(B5))

Popularity 4/10 Helpfulness 2/10 Language whatever

Source: exceljet.net

Tags: whatever pad excel spaces

Link to this answer
Share Copy Link

Contributed on Sep 22 2021

AlgoRhythm

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.