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
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
