Thread: Find entries lacking prefix and then add prefix.
View Single Post
 
Old 08-28-2017, 10:10 AM
gsteel gsteel is offline Windows 7 64bit Office 2016
Novice
  
Join Date: Aug 2017
Posts: 4
gsteel is on a distinguished road
Default 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?
Reply With Quote