Adding a column full of blanks

[Sean_RJ]

Good Day,

We need to add a column full of blank spaces as this is required by the system using the file. We need to add a column with 500 spaces.  I tried a pad but it requires a string from an existing cell.  In excel we would just use =REPT(" ",538).  

Thank you for your help

Sean

[Prometheus]

You can use a Formula tool to create a null.

 

[Felipe_Ribeir0 · Accepted solution]

Hi @Sean_RJ 

You can do something like this: