![]() text: This is the existing string of text that you want to amend.The formula syntax that we will be dealing with is “ =SUBSTITUTE(text, old_text, new_text)“. The Excel substitute function replaces existing text in a string with other text specified by you. The other 3 names do not return a valid result because the names are different in both cases. The two tables below will be used to demonstrate the Excel substitute function and multiple uses of the Excel substitute function.Ĭolumn B contains a VLookUp which is looking for the name in column A and retrieving the age from column F of the second table. In these cases, I use the Excel substitute function to make both databases more compatible. The same goes for where spaces are used in one database and not the other, like “Breda McDonald” and “Breda Mc Donald”. So a simple VLookUp between the two databases will not work. The most common type of incident I come across are where one database contains a name like “Adam O’Reilly” and another database has the name as “Adam OReilly”, with no apostrophe. I have been coming across more and more cases where people have problems with lookup formulas because databases do not have matching information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |