Modified broad match keywords causing issues on sheet - showing up as #NAME?

[Jay Wilner]

i posted this question before: 

https://developers.google.com/adwords/scripts/community/?place=msg%2Fadwords-scripts%2FttTR7CbXiVk%2F1RE0UcBm5KkJ

I am trying to write keyword text to a google sheet. for modified broad match keywords, the google sheet throws an error in the cells thinking the "+" signs are part of a formula.

is there any easy fix? is it some logic i have to add to the script before writing to the sheet or some script i have to create within the sheet to remove those errors?

someone on the prior post i had said to simply change the formatting of the column in the sheet to be 'text only' but that doesnt work.

thank you in advance!!

[Michae Thompson]

and then replace text generated with 
="[key word]"
=""key word""
="'+key +word"

('+) followed by (+)

Tag, you're it,

Miek

MiekWave SoundLab Stellar Soundtracks & Recordings™

817-291-4474 / miekwave...@gmail.com 

Studio 87, 500 E St Elmo Rd. Austin, TX 78745

 Google Partner | Elance | Odesk

    

Ask me to play piano at your event

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "AdWords Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/0a325182-0b83-4d7f-abb4-4e9ef287700c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.