Swapping column and row formats. Letters to numbers etc.

AdamNT69 · #1 10-17-2016, 04:19 AM

Hi All

For a report I need to export to, I need the columns to be numbers and the rows to be letters. I'm using Excel 2013 with the start globe (!) on Windows 10.

Can someone help.

Many thanks

Adam

xor · #2 10-17-2016, 07:42 AM

Can you be a bit more specific?

AdamNT69 · #3 10-17-2016, 08:44 AM

Hi

Where the columns are all listed from A to Z (and beyond), these need to be numbers and the rows, which are numbers need to be listed as letters.

A file needs to be uploaded in a CSV format this way for an external report, and no, I haven't a clue why they can't be like the rest of the world and do letter at the top and numbers down the side!

Thanks
Adam

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
more symbols for super/subscript numbers and letters	djc	Word	5	03-13-2015 10:54 AM
Captions mixing letters and numbers	trew	Word	7	11-21-2012 12:54 AM
Creating TOC with letters and numbers	tanababa	Word	1	04-28-2011 01:35 AM
mailmerge with letters of a different numbers of pages	roel1972	Mail Merge	0	02-21-2011 11:45 AM
changing column formats	herbycanopy	Excel	2	03-30-2010 09:11 PM