There are a few different ways that you can dissect a string in Excel. One way is to use the LEFT, RIGHT, and MID functions. Another way is to use the FIND and SUBSTITUTE functions. And yet another way is to use the REPLACE function. Let's take a look at each of these methods in more detail.
The LEFT, RIGHT, and MID functions are very similar. The only difference is that the LEFT function starts from the left side of the string, the RIGHT. . .