LinkBack URL
About LinkBacks
Hi, first post.
Like to be able to incriment by 1 a cell that also contains text
A1=XB3001
B1=XB3002
TIA
Hi, first post.
Like to be able to incriment by 1 a cell that also contains text
A1=XB3001
B1=XB3002
TIA
Last edited by nodeblaster; 01-18-2011 at 10:52 AM.
If you have the first entry in A1, then you can simple copy down the cell and it should auto-increment.
if you need a formula, then in A2:
="XB"&TEXT(RIGHT(A1,4)+1,"0000")
copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
If you select A1 and B1 and then drag to the right, it should automatically increment. Is this not working for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Or create normal numbers and format cell as "XB"0
Never use Merged Cells in Excel
Awesome response times!
This works ="XB"&TEXT(RIGHT(A1,4)+1,"0000") but only for the row
ie Like to fill in only A1 cell XB3001 and auto fill A2 to H20 cell XB3160
Although the other suggestions looked so simple, being a lower than novice with excel I couldn't get it to work.
Thanks
Here is mine explanation detailed:
Right click on the column
Format cells
Custom
Type: "XB"0
In B1 enter: ="XB"&TEXT(RIGHT(A1,4)+1,"0000") and copy across to H1
In A2 enter: ="XB"&TEXT(RIGHT(A1,4)+8,"0000") and copy across to H2 then copy A2:H2 down to row 20.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks