Thread
:
Find entries lacking prefix and then add prefix.
View Single Post
08-28-2017, 11:32 AM
NBVC
Windows 10
Office 2013
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
You can add a formula in an adjacent column like:
=IF(LEFT(A1,4)<>"XXXX","XXXX"&A4,A4)
copied down.
You can then copy this column and Paste Special >> Values over the original column and then delete the formula column.
NBVC
View Public Profile
Find all posts by NBVC