Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-30-2015, 01:59 PM
alex1fly alex1fly is offline Why does my data take up multiple fields?? Windows 7 64bit Why does my data take up multiple fields?? Office 2007
Novice
Why does my data take up multiple fields??
 
Join Date: Jun 2015
Posts: 3
alex1fly is on a distinguished road
Default Why does my data take up multiple fields??

In this spreadsheet, some of my data sprawls across multiple columns. For example the date takes up columns A, B, and C. I think it was done this way for visual purposes, but I'm trying to crunch some numbers and this format does not work for me. Is there a way I can condense my data down into single columns each?



I want the date in column A only, the next number in column B only, and the address in column H only.

Please see attached file for an example. It is only a sample; the actual document is thousands of records, and editing the source is not an option.

Thanks in advance!
Attached Files
File Type: xlsx xxWMtest.xlsx (8.8 KB, 10 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does my data take up multiple fields?? Multiple Text Fields in Form robstark Word 1 08-11-2014 11:26 AM
Project - variable data fields pmarc Word 7 04-04-2013 05:07 PM
Multiple identical fields snorkerz Word 4 06-25-2012 02:30 PM
Why does my data take up multiple fields?? 'If... then... else' - output dependent on multiple fields SiBrad Mail Merge 3 01-13-2012 02:56 AM
Using fields to repeat data throughout a document Brasada Word 0 07-20-2010 02:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft