Find entries lacking prefix and then add prefix.
I have a column with 6000 entries. Most start with XXXX then a part number. I need to change the prefix which I did using the Substitute function. Is there away to search out the entries that had no prefix and add the new prefix? Like an if not then concatenate perhaps?
I suppose I could have stripped all old prefixes where found. Then concatenate the new prefix to all entries. Is that the best method?
|