Formatting information

[Wayne]

Hello,

I exporting a report to excel. The report is exported in
Excel 5.0 format.

When the information is displayed in Excel I need to re-
format it to use in a report that I produce. Currently i
do this manually but would like to automate the process
using macro's.

Firstly I want to re-format the date in column A, the
information in this column are peoples names. This
appears in the format Surname, First Name I want to
change this to the format First Name Surname....eg
Bloggs, Joe becomes Joe Bloggs. How can I do this?

I have worked out hoe to re-format the other sections but
can't figure out how to resolve this issue.

Thanks

 

[Debra Dalgleish]

Chip Pearson has some instructions on his web site:

http://www.cpearson.com/excel/FirstLast.htm