0

I need to fill automatically by using 2-3 rows upto 1000.
To be specific - i have 2 separate columns one is common text with few numbers, and second one will increment for each cell.
Like i have the following text with numbers in all cells from row 1 to 1000 rows,
"A21L02341" read without apostro...