View Single Post
 
Old 08-28-2017, 11:32 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote