Adding '_' to the beginning of all values in a column

[JDaviesInch]

Hi,

I am trying to add an underscore (_) to the beginning of each cell within a column.

For example :-

1_Series becomes _1_Series

I can't use the Padleft function as each cell will have a different number of characters.

Thanks in advance

[atcodedog05 · Accepted solution]

Hi @JDaviesInch 

You can easily get this by using formula "_"+[Column]

Hope this helps 🙂

[Jonathan-Sherman · Accepted solution]

Hi @JDaviesInch,

There are two ways to approach this, depending whether or not you want to add the underscore to the beginning of more than one column.

One column approach using a formula tool to amend the value: Using this approach you'd select the individual field you wanted to update

'_' + [Column A]

 Multiple column approach using a multi-field formula tool to amend values: Using this approach you can tick the fields you want to update

'_' + ToString([_CurrentField_])

I've attached my workflow for you to download if needed with both approaches!

Kind regards,

Jonathan