LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Split one coloumn into 2 in Excel

Hi,

I have an excel spreadsheet where I have a lot of values in coloumn A.
I want to split this into A and B. ( like a snake )

Coloumn A have: 1000, 1001, 1002, 1003 etc
I want to have A: 1000, B: 1001, A: 1002, B: 1003 etc

Is there an easy way to do this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to search data in one coloumn gibbs Excel Worksheet Functions 2 February 28th 07 05:21 AM
how to copare digits in two coloumn in Excel? ahmed Excel Worksheet Functions 2 February 16th 07 06:11 AM
How do i add up every other coloumn in a linked sheet abs Excel Worksheet Functions 1 October 9th 06 01:09 PM
How to make Unique coloumn in Excel sheet ? V JHANJI Excel Discussion (Misc queries) 2 March 9th 05 10:04 AM
about coloumn wide Vikrant Vaidya New Users to Excel 1 December 8th 04 08:09 AM


All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"