Place space in postal code
Try:
Format("V5R5H6","&&& &&&")
& is the placeholder for characters in the source string, any other
character (space in this case) is always inserted at the position it occurs
in the format string.
"Ange" wrote:
Hello.
All I need to do is create a space in a postal code.
V5R5H6 to V5R 5H6 I need a formula.
Thank you !
|