Macro

Hello Peggy,

Hope you enjoyed your Microsoft Excel courses with Best STL.

Thank you for your question regarding Macros.

For a step-by-step guide on how to create and use Macros go to the following link:

http://spreadsheets.about.com/od/advancedexcel/ss/080703macro2007.htm

The formulas used during the training were as follows:

=LEFT(A2,SEARCH(" ",A2,1) - Produces the first name

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1) - Produces the last name.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer