Microsoft 365 and Office | Excel | For home | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
="A" & SEQUENCE(30)
Can I create a sequence of combined text and integers e.g. A1 A2 A3 A4 A5 in Excel? Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Can I create a sequence of combined text and integers e.g. A1 A2 A3 A4 A5 in Excel? Thanks.
Microsoft 365 and Office | Excel | For home | MacOS
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous
3 additional answers
Sort by: Most helpful
-
Bob Jones AKA CyberTaz MVP 435.7K Reputation points2023-06-06T00:34:15+00:00 That solution is fine one as long as you're good with the fact that all 30 cells contain a formula rather than their displayed results. It that could present a problem: Copy the range, leave it selected then use Edit> Paste Special - Values to replace the formulas with their result.
-
Anonymous
2023-06-05T04:27:00+00:00 Hi, p45cal,
Got it. Thanks for the big help :-)
Maning
-
Bob Jones AKA CyberTaz MVP 435.7K Reputation points
2023-06-03T17:52:23+00:00 Based on nothing more than what you've asked, sure. It's a only a series of text strings so just type A1 into a cell then use the Fill Handle to drag as far vertically or horizontally as far as necessary.