simonj Posted September 29, 2006 Share Posted September 29, 2006 I can usually find a way to do most things in Excel but this one has me stumped I have a large list of computer names that need changing. The original computer names are in the following format: ABC12348 ABC12349 ABC1234A ABC1234B ABC34567 They all start with ABC but I need to change the first number by adding 5 to it. Changing each entry on the worksheet individually will be a massive task as there could be as many as 1000 entries. Are there any Excel guru's out there who could show me a way to automate this process? Link to comment Share on other sites More sharing options...
Ghozer Posted September 29, 2006 Share Posted September 29, 2006 some VB code could do it... are you wanting 5ABC12348.. etc, or ABC512348..? Link to comment Share on other sites More sharing options...
simonj Posted September 29, 2006 Author Share Posted September 29, 2006 The change requires that the first numeric has 5 added to it, e.g. ABC12345 becomes ABC62345 ABC1234A becomes ABC6234A ABC34567 becomes ABC84567 There are also gaps in the sequence of names so I can't just change the first one and drag it down the column. Link to comment Share on other sites More sharing options...
simonj Posted September 29, 2006 Author Share Posted September 29, 2006 Talk about thinking too deeply about this, a simple find and replace does the trick eg Replace C1 with C6, C3 with C8 etc etc.... Why didn't I think of that before Link to comment Share on other sites More sharing options...
esme Posted September 29, 2006 Share Posted September 29, 2006 "thats BRILLIANT! why didn't we think of that ?" "...guess our brains are just too highly developed" - hhgttg Link to comment Share on other sites More sharing options...
rubydazzler Posted September 29, 2006 Share Posted September 29, 2006 On the topic of excel spreadsheets ... I need to do two lists, one with 5 April 2005 tp 4 April 2006, down the first column and the other with 5 April 2006 to 4 April 2007, second column to be the correct day and the other columns need to add themselves up as they get added to with daily cost info. It's really a money in, money out list sort of thing. I've tried and I got the dates but then I changed something and now I can't get them back. I also can't find out how to make the columns add themselves up. I'm a thicko I know, but can anyone help ne, pretty please ps in words of three syllables or less would be good Link to comment Share on other sites More sharing options...
esme Posted September 29, 2006 Share Posted September 29, 2006 you've probably changed the format of the date columns so check that they really are dates - select the column right click and i think it's cell format or something, and look at the SUM function for totalling columns of numbers Link to comment Share on other sites More sharing options...
Chumley Posted September 29, 2006 Share Posted September 29, 2006 Right click on this, save it somewhere and have a look at the formulae http://freespace.virgin.net/chumley.is/Cashbook.xls Link to comment Share on other sites More sharing options...
rubydazzler Posted September 29, 2006 Share Posted September 29, 2006 Right click on this, save it somewhere and have a look at the formulae http://freespace.virgin.net/chumley.is/Cashbook.xls Chumley, I think I you ... thank you soooo much and thank you also for the tips, esme ... Link to comment Share on other sites More sharing options...
Chumley Posted September 29, 2006 Share Posted September 29, 2006 You're welcome, glad I could help. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.