Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pull first character from a cell?
you answered your own question... if you need a space in there do this: =B1&" "&Left(A1, 1)- joeny1980
- Post #3
- Forum: Microsoft: Office
-
Pivot Table grouping
This would be very easy to do. Create another column, call it "Group" And now put in a very simple formula that says: =IF(B3<30,"30 or Under","Over 30") Assuming B3 is where your Age is. Write whatever you want in the quotes. Now you can sort it or do whatever you want to analyze/group the...- joeny1980
- Post #6
- Forum: Microsoft: Office
