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!

 

[Fluff]

How about
=IF(ISNUMBER(SEARCH("March",A10)),"March","")

 

[helpexcel]

@Fluff, your genius know no bounds! thank you!

 

[Fluff]

You're welcome & thanks for the feedback

 

[helpexcel]

how would i incorporate that into a sumif? and can i us a reference list? So if text in A10:A30 contains a month the month is shown in B10:B30

 

[Fluff]

I don't understand what you are asking.

Can you please post some data, along with an explanation of what you are trying to do & sample results.

 

[helpexcel]

I have data in Column A that includes text, which also has the month. I'm trying to sum by month, with the months listed in column B.

Data In Out
In January 1 January 1 January 0
In March 2 February 0 February 4
In April 3 March 2 March 0
Out February 4 April 3 April 0
Out June 5 May 0 May 0
In July 6 June 0 June 5
July 6 July 0
August 0 August 0
September 0 September 0
October 0 October 0
November 0 November 0
December 0 December 0

 

[Fluff]

That data has no comeout very well, there are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html
that enable you to post data to the board

 

[helpexcel]

Column A Column B Column C
[TABLE="width: 560"]
<tbody>[TR]
[TD]Data[/TD]
[TD][/TD]
[TD][/TD]
[TD]In[/TD]
[TD][/TD]
[TD][/TD]
[TD]Out[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]In January[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]January[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]January[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]In March[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]February[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]February[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]In April[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]March[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]March[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Out February[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]April[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]April[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Out June[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]May[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]May[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]In July[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD]June[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]June[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]July[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD]July[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]August[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]August[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]September[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]September[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]October[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]October[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]November[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]November[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]December[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]December[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Whilst that is better, it's still not clear what is in which column, you say cols A,B 7 C, but it looks like you have 6 columns.
Also I cannot see where those numbers come from, or what you are trying to sum.