Mar 19 2021 08:26 AM
I need to add a prefix to any 7 digit number in a column containing numeric and alpha-numeric data.
Mar 19 2021 10:00 AM
Mar 19 2021 12:17 PM
@mtarler Yes, we may only make different guesses what the question actually means. My understanding you shall first check if that's the number or text since column contains both and texts also could be 7 characters length.