Question Help with reading and writing excel spreadsheets

taharokz

New member
Joined
Sep 2, 2009
Messages
1
Programming Experience
1-3
Hey i need a program that will read data from 1 column in an excel spreadsheet and then find a specific character in each record then copy all text before that character into the column next to it.

for example if you had an email address like johnsmith@hotmail.com in A1 it would take all the text before the @ (johnsmith) and copy it in into A2. any help will be greatly appreciated
 
Top Bottom