LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Merging a ton of cells

basically i have a worksheet that starts with number 5120001 and each
cell thereafter increases by one. i want to group these numbers into 20
numbers in each cell. ie. A1 would look like:

-----
5120001
5120002
5120003
5120004
5120005
etc
------


is there anyway i could do this and automate the process so i wouldn't
have to do it manually for 20,000 cells?

 
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
Merging cells with the same values Iain Excel Discussion (Misc queries) 0 August 8th 05 06:35 PM
Merging Two Cells and Keeping the Values Raymond Excel Discussion (Misc queries) 10 May 30th 05 08:05 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
Merging cells with text as one line Jim Excel Worksheet Functions 1 December 23rd 04 01:29 AM
Merging Cells BruceT Excel Worksheet Functions 1 December 2nd 04 06:38 AM


All times are GMT +1. The time now is 05:28 PM.

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

About Us

"It's about Microsoft Excel"