Please help correct my formula - copy/paste results in carriage return and quotes around text

Ami Veltrie

Here is my formula:

=[Client Name (Avi)]@row + "-" + LEFT([Request Category]@row, 1) + "-" + MID(Created@row, 7, 2) + "-" + [Request ID]@row + "- " + JOIN([Services Requested - Utility]@row + [Services Requested - Waste]@row + JOIN(" -P"))

When I copy/paste the cell (or export to Excel), the text looks like this (two rows, with quotes):

"Client Name-O-22-01986- Electric

-P"

Mike TV

@Ami Veltrie

I reproduced your sheet and formula. When I copy-paste it into a Google Sheet it looks like this:

So I'm guessing your problem isn't within SmartSheet. Quite possibly the cell in Excel which you are pasting it into has certain formatting which could be causing this? I'd check there for a solution. Maybe open a new Excel or Google Sheet which will have all default formatting and see if it still happens there?

Ami Veltrie

@Mike TV

I just tried to copy/paste into Teams and Word, I get the same wrap and the quotes.

I even pasted into a blank Smartsheet and it still wrapped:

Ami Veltrie

@Andrée Starå Hello! Is there any way you could help me with this?🙏

stephenbgarza

Has there been any resolution to this problem? Thank you.