Why is copy and paste adding characters?
I am trying to copy and paste rows over from Excel to Smartsheets. It does work; however, it is adding extra characters to smart sheet.
I attached a picture so you can see. Here is the original excel, and then what it looks like in Smartsheet.
Is there any work around this?
Answers
-
Hi @mloveday87
Since Smartsheet and Excel are separate programs there can be differences when data is copy/pasted from one to the other. What type of data in the excel file is turning into characters in Smartsheet, is it possible that there is a formula in excel that Smartsheet doesn't recognize?
Would you be able to post the excel file you're using with sample data? I'd like to test this on my own account to see what could be the cause.
Thanks!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives