Using the tabs to align data

Excel Help for Using The Tabs To Align Data in Developing Business Administration Solutions

Using The Tabs To Align Data

Rate this: (3/5 from 1 vote)

	In the example for the text file, it seems you want the third column of data for each product type. In this case, you can specify the start texts as the items required (e.g. 'Food'). The end text can be a new line. When the data comes in as one column, we can use the text to columns command in Excel to split the data out with the tab delimiter and then get all data lined up next to the items.
	Excel Business Forums Administrator
	Posted by Excel Helper on 27 Nov 2013

View Full Post