Changing Row of numbers into column or similiar

		Microsoft Office Forums > Microsoft Excel > Excel
Changing Row of numbers into column or similiar

FAQ

Thread Tools

Display Modes

01-12-2018, 06:38 PM

macropod

Windows 7 64bit Changing Row of numbers into column or similiar

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

If the data are supplied as a text file, you really don't need Excel or a macro for this. All you need do is open the text file (even NotePad will do) and use Find/Replace to replace the spaces with line breaks.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing Column's Width in Tables	mohsen.amiri	Word Tables	4	11-03-2014 01:04 PM
How to change the formatting of numbers without changing the numbers?	sullengirl	Word	2	01-27-2014 03:06 PM
Column Width keeps changing	alsmith	Word Tables	1	05-25-2013 02:09 AM
Changing Caption Numbers	RunningPirate	Word	2	09-03-2011 07:42 AM
changing column formats	herbycanopy	Excel	2	03-30-2010 09:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 PM.