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

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

<tbody>
</tbody>

 

[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.