Microsoft Office Forums Find entries lacking prefix and then add prefix.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-28-2017, 10:10 AM
gsteel gsteel is offline Find entries lacking prefix and then add prefix. Windows 7 64bit Find entries lacking prefix and then add prefix. Office 2016
Novice
Find entries lacking prefix and then add prefix.
 
Join Date: Aug 2017
Posts: 3
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
  #2  
Old 08-28-2017, 11:32 AM
NBVC's Avatar
NBVC NBVC is offline Find entries lacking prefix and then add prefix. Windows 10 Find entries lacking prefix and then add prefix. Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 202
NBVC 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
  #3  
Old 08-28-2017, 11:36 AM
gsteel gsteel is offline Find entries lacking prefix and then add prefix. Windows 7 64bit Find entries lacking prefix and then add prefix. Office 2016
Novice
Find entries lacking prefix and then add prefix.
 
Join Date: Aug 2017
Posts: 3
gsteel is on a distinguished road
Default

Many Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find entries lacking prefix and then add prefix. Indexing a long document with specific prefix jaydee Word 8 08-28-2017 05:51 PM
Add prefix to .csv from excel Reg06 Excel 1 12-06-2015 05:06 AM
Find entries lacking prefix and then add prefix. Find superscript numbers with a prefix of some default text AlexandarR Word 7 05-20-2015 07:57 AM
Find entries lacking prefix and then add prefix. Add Standard Prefix To Cells zulhfreelancer Excel 1 06-14-2013 04:12 PM
Find entries lacking prefix and then add prefix. Find & Replace words with "/" prefix & suffix tollanarama Word 4 01-25-2011 02:19 AM


All times are GMT -7. The time now is 06:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft