Excel Cells

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Excel Cells

Logged in as: Guest

arrSession:exec spGetSession 2,2,1199

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Excel Cells
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Excel Cells - 7/30/2004 8:44:49 AM

Asynch

Posts: 2
Score: 0
Joined: 7/30/2004
From: USA
Status: offline

I get lists of employees in multiple formats, ie. last name, first name or last name in one column and then first name in the 2nd column. I am constantly trying to reconcile different lists also in excel and I am looking for a macro that will strip out the first name and the mi from a "lastname, firstname mi" type listing and move the data to the next column over, dropping the comma altogether. I tried playing with the macro recorder, not a good move. I am very new to scripting, tho I am attempting to teach myself as I go and I would be very appreciative of any help.

Thanks,

_____________________________

Asynch

Honor Above All

Post #: 1

Re: Excel Cells - 7/30/2004 10:46:35 AM

mbouchard

Posts: 1916
Score: 16
Joined: 5/15/2003
From: USA
Status: offline

If this is in excel, just select the column that you want to seperate, click on data, click on text to columns, choose delimited and select comma. This will take column 1 (Last, First, Mi) and seperate it into 3 columns. Make sure to have the 2nd and 3rd columns empty as it would overwrite what is already there.

If this is in a text file just rename it to CSV and open in excel.

(in reply to Asynch)