Adding spaces into a nested formula

[F4TMAN]

Does anyone know how I can add the "#####" into a formula? essentially what I'm trying to accomplish is adding 5 leading spaces before returning value.

e.g. If the returning value is "Students" then it should look like this
Students (5 spaces before the returning value)
Students (no spaces added before "students)

Here's my formula

=IFERROR(INDEX(Ref!F$2:F$165,MATCH(VALUE(MID(TRIM(E257),4,4)),Ref!C$2:C$165,0)),"")

The returning value is "Ref!F$2:F$165"


Thanks!

 

[Gimics]

Hey there - does using the =TEXT() formula work for you?

=TEXT(your formula here,"     @")

 

[F4TMAN]

Hey there - does using the =TEXT() formula work for you?

=TEXT(your formula here,"     @")

Perfect! nice and easy that worked. Thank you!