#1
|
|||
|
|||
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
|
||||
|
||||
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. |
#3
|
|||
|
|||
Many Thanks
|
Thread Tools | |
Display Modes | |
|
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 |