Autofill Characters with numbers in front

craigwojo

Board Regular
Joined
Jan 7, 2005
Messages
188
Hi,
Need to autofill the characters ONLY with a number value staying the same.

example.
E48A
E48B
E48C
etc. through "Z" without the letters I and O

thank you and God bless,
Craig
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
So, are you starting with "E48" or "48"?
If "48", how do you know that you want an E to start?
And, are there multiple numbers, and do you start over when the number changes?

Is a VBA solution acceptable?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
You only answered 1 of the 4 questions I posed. Please answer all of them.
In order to give you the best help, we need you to provide as many details as possible.

Also, is the first value populated already?
If not, where is the E48 coming from (or will it always be E48).
 

Forum statistics

Threads
1,085,503
Messages
5,384,065
Members
401,879
Latest member
wzakaria

Some videos you may like

This Week's Hot Topics

Top