Excel: separating names into new columns with text to columns

Scripting Forums AppleScript | Mac OS X
#1

Hi All,

I’m trying to separate a column of names in excel 2008 that is in the following format: “LastName, FirstName”. Using text to columns it successfully does this delimited by the comma but not by comma and space which leaves a space before all of the names. Is there a way to make it delimited by both comma and space?

Thank you!


tell application "Microsoft Excel"
	activate
set AppleScript's text item delimiters to ", "
text to columns (range "G8:G8000" of worksheet "Sheet1" of active workbook) destination range "H8" data type delimited
end tell