Formatting Collums, for Appending purpose

nguyenthanhtrung

Forums

Hello everybody,
I am having difficulty in appending multiple sheets importing from excel. Why i tried to join these sheet together, the system notify me about the field format is different. Is there a way or any tips to mass formatting multiples sheets at one? Since having 50+ sheets to append might be time consuming.
Thank you very much,
Best regards,
Trung Nguyen

Brian Element Thu, 10/19/2017 - 10:36

Hi Trung,

I did have a script that I did for someone that converts all the fields into character before the append.  I will try and find that script and post it for you.

Brian

Steven Luciani Thu, 10/19/2017 - 14:21

Hi Trung,

I have this issue quite often. Attached is the version of the script Brian wrote that I use when I encounter this problem.

Cheers,

Steve

nguyenthanhtrung Wed, 10/25/2017 - 04:39

Thank you Steven and Brian very much for your support, i find this script very helpful.
Best regards