Hello! I am trying to extract and copy text that is in between the first and second colon ":" in each cell in column A and copy said text into column B. In this example, "California" is the text in between the first and second colon ":" but that will not always be the case. The problem that I am having is that that are additional colons that are in each cell. How would I achieve this? Thanks in advance!!
United States:California:Alameda:Oakland |
United States:California:Alameda:Berkeley |
United States:California:Alameda:San Leandro |
United States:California:Alameda:Castro Valley |
United States:California:Alameda:Dublin |
United States:California:Alameda:Pleasanton |
Last edited by a moderator: