Hi all,
I need to concatenate strings with the criteria that the text starts with :86: untill :61:.
For below example every new line is a new row in excel and everything is in column A. in B1 I would like to see the concanate of A1&A2&A3 since in A4 the line starts with :61:
I tried to do this with a formula but I couldn't figure it out. I think the best way would be a macro but I am open to suggestions.
<tbody>
</tbody>
I am using excel 2010 on windows 7.
I need to concatenate strings with the criteria that the text starts with :86: untill :61:.
For below example every new line is a new row in excel and everything is in column A. in B1 I would like to see the concanate of A1&A2&A3 since in A4 the line starts with :61:
I tried to do this with a formula but I couldn't figure it out. I think the best way would be a macro but I am open to suggestions.
A | B | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody>
</tbody>
I am using excel 2010 on windows 7.