|
|
#1
08-28-2017, 10:10 AM
|
|||
|
|||
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? 
|
|
#2
08-28-2017, 11:32 AM
|
||||
|
||||
|
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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 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 superscript numbers with a prefix of some default text
|
AlexandarR | Word | 7 | 05-20-2015 07:57 AM |
|
Add Standard Prefix To Cells
|
zulhfreelancer | Excel | 1 | 06-14-2013 04:12 PM |
|
Find & Replace words with "/" prefix & suffix
|
tollanarama | Word | 4 | 01-25-2011 02:19 AM |
Windows 7 64bit 
Office 2016
Linear Mode
