Excel help

  • Thread starter Thread starter Gary Newman
  • Start date Start date
G

Gary Newman

Hi,

Two questions.
First is, when performing a Pivot Table, is there a way of
changing the source so that when you produce a pivot
table, the months are in order.

And, when you concatenate and join a surname and first
name together, how do you then separate them ?

Thanks
 
Gary Newman said:
Hi,

Two questions.
First is, when performing a Pivot Table, is there a way of
changing the source so that when you produce a pivot
table, the months are in order.

And, when you concatenate and join a surname and first
name together, how do you then separate them ?

Thanks
Click to expand...

Firstly, in future, please put only one question in each post and use a
descriptive subject line. All posts in this newsgroup are for help with
Excel!

If you use real dates and group data by month within the pivot table, the
months will be in order. Have you just used text for "January", "February",
etc.?

For an entry such as "John Smith" in A1,
=LEFT(A1,FIND(" ",A1)-1)
and
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
will produce "John" and "Smith" respectively.
 
Back
Top