Hello I have an excel spread sheet with a column called Acct_ID. Heres what I'm trying to do.
I have a column with account numbers in this form:
R12345
M23456
T12345
I'm trying to convert the first letter to a sequence of numbers then keep the remaining numbers. For example
R12345 to 10012345
M23456 to 20023456
T12345 to 30012345
I've created the following code to do so. But there's syntax errors and I'm unsure of what is wrong in my update query.
iif(left(ac,1)="R";"100"&right(ac,5);iif(left(ac,1 )="M";"200"&right(ac,5);iif(left(ac,1)="T";"300"&r ight(ac,5)))
Any ideas?