ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formula to split accounting codes in one column into 2 columns

nobbsl
5 - Atom

Hi there, I'm very new to Alteryx and hoping someone can please  help me with a formula.

 

I have an excel spreadsheet with various accounting codes in 1 column (see attached).

 

I need to split the codes into 2 columns based on their leading character i.e. Codes starting with a letter be placed in a new column labelled "Project Code" and codes starting with a number be placed in another column labelled "Cost Centre".

Is anyone able to help me with a formula to do this please?

 

Thanking you in advance

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@nobbsl 
I am using RegEx to check if the first letter is number of letter.

0123-nobbsl.png

Labels
Top Solution Authors