msduck283

Thank you for trying to help me....I was able to do some calculations in Excel to get the information the way I need it. Again thank all of you.

Sorry about that...the data in Excel is separated by tabs. Thanks for any help.

I have data being imported from Excel (from many different sources) into a database...due to the way the excel template was originally set up, the name field is all one field...but within the database it needs to be broken down into fields by Title, First Name, Middle I. and Last Name. I'm in need of a calculation that can do this for me. Any help with this would be appreciated.

Hello, I've got a simple script to get the file path of folders and enter it into a clickable field. set folderChoice to (choose folder) as string set cell "location" of current record of layout "Main" to folderChoice It runs great the first time I use it, when I use it again....I receive the following error... Data is being accessed by another user, script, or transaction.(Error -10011) Any help would be appreciated. Thanks!