Notifications
Clear all
General Discussion
2
Posts
2
Users
0
Reactions
86
Views
Topic starter
Is there a way to use Excel to maintain custom lists. I tried to export a medication custom list and edit it in excel, but I am having issues with saving it back out with the propper delimiter. Has anyone had success with this?
Posted : October 9, 2013 8:09 am
I have done it. I basically make a formula at the end of the first row that is like:
="[" & A1 & "][" & B1 & "][" & etc.
so that the formula successfully duplicates a row format from the clinical kit. I then copy the formula down the column for every row then copy that entire column and paste it into a text editor. Add a beginning line that has the row count and number of columns and a blank line at the end and that should give you your .MLC file for the clinical kit.
Posted : October 15, 2013 6:12 am
