HELP WITH IF/THEN formula HELP..

[Hannah Lee]

I need help with following. I need the SIZE AND COLOR to populate depending on what it says in the column A.
column A will have color and size... but i need to know formula that would show this in column B and C.

PLEASE VIEW THE IMAGE BELOW.

 

[VoG]

Try like this

Excel Workbook
	A	B	C
1		Size	Color
2	red abc
3	red abc - large	large	red
Sheet3

 

[Andrew Poulsom]

Try:

=MID(A3,FIND("-",A3)+2,255)
=LEFT(A3,FIND(" ",A3)-1)

 

[Hannah Lee]

can you please help if in this view? column A and column B also has the information i need.... So i think we can do IF/THEN formula instead?

Thanks,
Lee