VBA to pull text out of cell

[helpexcel]

Hi - Is there a way to say look in A10 and if the word "March" appears, put "March" in B10?

Thanks!

 

[helpexcel]

That is showing columns A-F. I altered your formula slightly =IF(ISNUMBER(SEARCH(=CONCATENATE("In"," ","March"),A10)),"March","") because i wanted to bucket the months into In(Column C) and Out(Column E). I then want to sum each "In" month in column A and put that in the corresponding row in Column D. Same for the "Out" months.

 

[Fluff]

Is this what you mean.
In D2 copied down
=SUMIF($A$2:$A$13,$C$1&" "&C2,$B$2:$B$13)

 

[helpexcel]

WOW, do i tend to overthink things. Very simple solution, THANK YOU. I need to populate the months first, but I can handle that.

 

[Fluff]

You're welcome & thanks for the feedback

 

[helpexcel]

Sorry one last iteration. instead of breaking it out by month and totaling, Is there a way to change this "=SUMIF($A$2:$A$13,$C$1&" "&C2,$B$2:$B$13)" to say sum all values in column A that start with "in"?

 

[Fluff]

Yup, just use
=SUMIF($A$2:$A$13,$C$1&"*",$B$2:$B$13)

 

[helpexcel]

perfect, thank you!

 

[Fluff]

You're welcome & thanks for the feedback