I am not able to copy and paste Teams message with Time and sender name

Glad to know that it assists a bit and gives some ideas :)

and for whatever reason my teams post the time below regardless of who Person 1/2 is i had to change P52

I think I know why, perhaps you are using Compact Chat Density? (Settings > Chats and Channels > Chat > Message Density > Compact)

I tested in mine with compact and when I copy it does place the time at the bottom of the name for both the Person1 & 2.. I did not realize that before.

to make your formula work for AM/PM had to change your "3" to a "6" to account for the extra characters
=IF(LEFT(RIGHT([@Input],6),1)=":",

           "["&[@Input]&"]", 

".")

and for whatever reason my teams post the time below regardless of who Person 1/2 is i had to change P52
=IF([@IsDateFormat]<>".",

  IF(A8=$A$2,

               [@IsDateFormat] & " " &A8,

         IF(A10="Edited",

               [@IsDateFormat] & " " &A11,

         IF(A8=$A$4,

               [@IsDateFormat] & " " &A8,

               "."))),

".")

I think some of your formulas and fields are redundant but assuming you kinda just slapped this together to get your desired result. i appreciate the start and ill retool to my needs when something else about teams copy pasting pisses me off

Thank you, I will give it a try.

I tried it. First, it is through the Microsoft store so you may not need approval to get it installed. I didn't and we have a strict policy on extras. Second, it doesn't work very well. It made some odd translations for some of the text and if others are "reacting to chats with emojis it really gets funky. Microsoft just needs to act and fix this for the majority who want it instead of the minority who don't.

@KStart See my post on December 16, 2024 (page 4 of this thread, as that's where it is as I view this) on how to clean up the conversation (remove the summary 'yah dee da by whosaid it' and append the time stamp after who said it) - find/replace in Word and Outlook is all that's needed.

Note that my find/replace is written for how my machine is set up, and it's for English. Foreign characters are not accounted for.