Multiple data in one cell?

		Microsoft Office Forums > Microsoft Excel > Excel
Multiple data in one cell?

FAQ

Thread Tools

Display Modes

09-06-2013, 02:50 AM

C J Squibb C J Squibb is offline

Windows 7 64bit Multiple data in one cell?

Office 2010 32bit

Novice

Join Date: Aug 2013

Location: Essex

Posts: 14

You could enter the data into three different columns, then merge them into a text string in a fourth column, using the CONCATENATE function, for use in the pivot table if that gives you the results you want.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Formulas in one Cell one Formula Away From Completion	microsoftnovice	Excel	2	12-05-2012 12:54 PM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
Splitting Excel cell into multiple	ruben23	Excel	1	07-23-2009 03:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 PM.