LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default add multiple letters to the end of multiple cells

i am wondering if it is possible to add letters from A to F, to multiple cells in a column. what i have is six cells in a column with the text "sc-2346" starting in cell A1 and going down to A6, then the next six cells (A7-A12) contain the text "sc-2349". what i want to do is add the letters A-F to those 6 cells so that A1 ends up reading "sc-2346A", A2 reads "sc-2346B".....A6 reads "sc-2346F". then i want to be able to repeat this process with the next six cells. please let me know if you know how to do this, if its even possible or any knowledge you might have. thanks!!
 
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
Select multiple adjacent cells of multiple cells without selecting sjsjsjsjsjs New Users to Excel 11 December 24th 09 01:09 AM
Select multiple adjacent cells of multiple cells without selecting sjsjsjsjsjs Excel Worksheet Functions 7 December 23rd 09 08:54 PM
Counting specific letters in multiple cells tohlz Excel Worksheet Functions 4 July 4th 08 08:55 PM
macro copy/paste data from multiple cells to multiple cells Diana Excel Discussion (Misc queries) 0 July 10th 06 09:24 PM
make multiple cells in 1 worksheet equal multiple cells in another riley454 Excel Worksheet Functions 1 January 19th 06 03:00 PM


All times are GMT +1. The time now is 04:00 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"