a1: EDCU-1334A
Trying to copy and paste this so the result will be
a2 : EDCU-1334B
a3 : EDCU-1334C
a4 : EDCU-1334D
Just trying to make it quicker to populate instead of having to retype everything out.
a1: EDCU-1334A
Trying to copy and paste this so the result will be
a2 : EDCU-1334B
a3 : EDCU-1334C
a4 : EDCU-1334D
Just trying to make it quicker to populate instead of having to retype everything out.
Go to Option, Advanced > General > Edit Custom List > Add a custom list (A,B,C....,Z)
In cell A1 Type EDUC-1334 (Copy it down without fill series). In Cell B1, Type A then drag it down. In Cell C1, type =A1&B1 then drag it down
Hi there,
what JieJenn described would work but just dragging the first cell (A1) with the value EDUC-1334A down the column and filling series should work also.
hope this helps,
Fidd$
incorrect solution by me. tried to edit and delete but no joy![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks