Concatenate, If , And Functions combined

Thanks for the reply! I will be attaching the excel sheet as adviced by martindwilson..

Thanks for the heads up! I will attach the excel file..

Originally Posted by Ron Coderre

Can you post the results you want to happen for the before/after market close situations?

I have attached the excel file..In my formula I manually added AMC but I want it to be automated. Column D has After Market Close and Before Market CLose. I want to incorporate that into my formula whereas if it is After Market Close, then it will be AMC and if it is Before Market Close, then it is BMO..

Originally Posted by martindwilson

please Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Hi Martin! I have already attached the excel file..

Originally Posted by Ron Coderre

Using your posted workbook....
this regular formula inserts the appropriate acronyms:

Formula:

Please Login or Register  to view this content.

Is that something you can work with?

Wow! Thank you very much Ron! You are such a great help..My problem has been solved thanks to you!

Originally Posted by Ron Coderre

Your very welcome...I'm glad I could help.

Another question, I don't know if this is allowed but I have used the formula in google spreadsheet but it doesn't work there..using the formula you have given, the result was triplicated if used in Google Spreadsheet.