Forum Discussion
mjackson
3 years agoRegular Visitor
sorting one column into two
Hey everyone so here is the issue, I have a column with mixed codes. They are CPT and HCPCS codes. Both are the same number of characters. The CPT codes do not contain letters and the HCPCS codes do....
serpiva64
Solution Sage
3 years agoHi,
you can duplicate your column
in the duplicated column change Type to Whole Number and replace errors with null
now add a conditional column
and rename your columns
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!