Please help me in solving this

[fahadferoz01]

I need to extract the full name of province/state from column A. The full name of province/state should appear in column B. For example, in cell B2, the text string Texas should appear. Need to type up the formula in cell B2, and then drag the formula down to cell B9.

 

[arthurbr]

Looks like homework to me...

 

[fahadferoz01]

i am sorry but is exercise forbidden to post here. if anyone needs help. i tried solving this. but failed. any info on this would help me on the next post.

 

[footoo]

Why not do a web search for : "excel formula to extract string between two characters" ?

 

[fahadferoz01]

ok

Why not do a web search for : "excel formula to extract string between two characters" ?

thanks.

 

[Joe4]

You have posted class/homework assignments here in the past too. Please do not expect us to do your assignments for you, that would be unethical, and that is not what this board is designed for.

Members here would be willing to critique what you have tried, or give some "hints" (like footoo did above). However, you should post what you have tried so that we can see you are making an effort, and we can provide some guidance on it. So far I have only seen you post the questions, without showing any work or any of the things that you have tried.

 

[fahadferoz01]

You have posted class/homework assignments here in the past too. Please do not expect us to do your assignments for you, that would be unethical, and that is not what this board is designed for.

Members here would be willing to critique what you have tried, or give some "hints" (like footoo did above). However, you should post what you have tried so that we can see you are making an effort, and we can provide some guidance on it. So far I have only seen you post the questions, without showing any work or any of the things that you have tried.

Ok. so how can i show i have tried? any help on that please

You have posted class/homework assignments here in the past too. Please do not expect us to do your assignments for you, that would be unethical, and that is not what this board is designed for.

Members here would be willing to critique what you have tried, or give some "hints" (like footoo did above). However, you should post what you have tried so that we can see you are making an effort, and we can provide some guidance on it. So far I have only seen you post the questions, without showing any work or any of the things that you have tried.

 

[Joe4]

Ok. so how can i show i have tried? any help on that please

Post any formulas or VBA that you have tried.

 

[fahadferoz01]

o

Post any formulas or VBA that you have tried.

ok. thanks. am showing you right now.

 

[Joe4]

ok. thanks. am showing you right now.

Where?