A list of numbers increased by one.
Hi there.
I have been searching everywhere for help on this topic. Please, if anyone has any insight, I would greatly appreciate it.
I would like to save time by having a list of numbers increase by one, but not change ALL of the number.
eg)
ME2029001 down the column with every number up to ME2029400.
What is the formula for this?
Thank you in advance,
Greg Bolton
Assistant Business Manager
Seasons Retirement Communities - Dufferin Centre, Trenton, ON.
Welcome to the forum.
If the text is always of the form letter-letter-numbers, then
=LEFT(A1, 2) & RIGHT(A1, LEN(A1)-2)+1
Entia non sunt multiplicanda sine necessitate
You won't need a formula.
Put ME2029001 in A1
Pulll the autofill cross in the rightdowncorner to A400 and you are ready.
A macro as alternative:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks