as above ;-)
UB01A
UB01B
UB02A
UB02B
UB03A
UB03B
UB04A
UB04B
UB05A
UB05B
Thank You :-)
PS. Alternatively how to replace letter B with C in the above string ;-)
as above ;-)
UB01A
UB01B
UB02A
UB02B
UB03A
UB03B
UB04A
UB04B
UB05A
UB05B
Thank You :-)
PS. Alternatively how to replace letter B with C in the above string ;-)
Last edited by SoftKiller; 01-15-2019 at 06:13 AM.
Put this formula in your starting cell (e.g. A1):
="UB"&TEXT(INT((ROWS($1:1)-1)/2)+1,"00")&CHAR(64+MOD(ROWS($1:1)-1,2)+1)
then copy down as far as you need to. You may need to use semicolons ( ; ) in the formula instead of commas ( , ), depending on your regional settings.
Hope this helps.
Pete
Nice stuff Man! Will try it when get back to office ;-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks