How to make Oracle L/RPad Function to MS Excel

REPT (text, number_times)

Oralce LPAD : REPT(rept-text, total text size, LEN(text))&text
Oracle RPAD : text&REPT(rept-text,total text size, LEN(text))