Pivot Table Field Alignment

[timely]

I have a pivot table that has a field that contains sever all things of informatio and am trying to get it to align a certain way. It look like this in the field:


020202 john henry VC 123454534212 fkjdf
040302 max lock MX 342342343444 jdfls
090403 Jennifer Whobio MC 234234234234 fgfdg

This is in just one field from a database table.

I need it to align as so in the pivot table.

020202 john henry VC 123454534212 fkjdf
040302 max lock MX 342342343444 jdfls
090403 Jennifer Whobio MC 234234234234 fgfdg

I know it can be done because it was done another pivot table that we have but I can not find the formatting setting that they used.

How can I get it to align one field as so?

Thanks,
Tim

 

[mscallisto]

The examples in your post look the same to me so I can't understand what you want.

Can you explain it more?

Here are general pivot table instructions

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

 

[timely]

The formatting changed when it got posted, sorry.

Okay I need the mc and vc and mx to line up so that the number after it will also line up. Basically so that all starts after whitespace line up.

Tim

 

[SkipVought]

Hi,

What you are asking is not at all clear. Does the SECOND Row field contain john henry VC etc

If so, Format the FONT as Courier New

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[timely]

Yes, and thank you that worked. Sorry if not clear but what you said worked.