Forum Discussion
remove first character if it is a 2
I would like to remove the first character if it is a 2. Thanks in advance
Anonymous Try this as a New Column
NewData = IF(LEFT([Data],1)="2",MID([Data],2,LEN([Data])-1),[Data])
PattemManohar
Community Champion
Community ChampionAnonymous Try this as a New Column
NewData = IF(LEFT([Data],1)="2",MID([Data],2,LEN([Data])-1),[Data])
Worked perfect. Thanks for your help