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: 5
Default adding a,b,c,etc to end of item in call

I have two columns. Col A is "acct nos" where some acct nos are repeated 2,3
or 4 times and some only twice. The second column is random file names, such
as 0001325.jpg. I would like to be able to to rename the 2nd column with the
1st column acct no name and add an a,b,c, etc(however many times the account
no is listed). my "new" name would be something like 0100252401a.jpg,
0100252401b.jpg, etc.
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
sort bar chart in excel BuriedInSpreadSheets Charts and Charting in Excel 6 May 31st 07 04:12 PM
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG EmanJR Excel Worksheet Functions 1 August 3rd 06 03:47 PM
Fill in form to type Item descrictions and costs and fill in funct cradino Excel Worksheet Functions 0 July 16th 06 08:44 PM
Need to sum up numerous columns in different worksheet into 1 devil135 New Users to Excel 3 May 26th 05 03:32 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 10th 05 11:37 PM


All times are GMT +1. The time now is 08:27 AM.

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"