Hello,
I have a column of cells which contains strings of text separated by line breaks.
Is there a formula which I could use to find a string which starts with specific text and pull that string into the adjacent cell?
For example, in the table below "Massachusetts:..." appears in multiple cells with a different city after the ":"
Is there a formula to enter in the adjacent cell in Column B which searches for "Massachusetts:" and returns the entire string (i.e. Massachusetts: City) regardless of which line it appears on in each cell in Column A?
Thank you for your consideration of my question
I have a column of cells which contains strings of text separated by line breaks.
Is there a formula which I could use to find a string which starts with specific text and pull that string into the adjacent cell?
For example, in the table below "Massachusetts:..." appears in multiple cells with a different city after the ":"
Is there a formula to enter in the adjacent cell in Column B which searches for "Massachusetts:" and returns the entire string (i.e. Massachusetts: City) regardless of which line it appears on in each cell in Column A?
Thank you for your consideration of my question
Column A | Column B |
Massachusetts: Boston Connecticut: Hartford California: Los Angeles | Massachusetts: Boston |
Connecticut: New Haven California: San Diego Massachusetts: Boston | Massachusetts: Boston |
Connecticut: Hartford California: Sacramento Massachusetts: Salem | Massachusetts: Salem |