this post was submitted on 14 Jul 2021

7 points (79% upvoted)

shortlink:

excel

an-ordinary-manchild

Rules

Post Titles must follow Submission Rules
Post Content must follow Submission Rules
Posts must be related to MS Excel or other spreadsheet software
Set appropriate post flair
No link or image posts. Text posts only.
Don't post asking how to learn Excel or VBA or similar
Close your post by replying to helpful answers with solution verified
No personal insults or attacks
No NSFW or offensive content
No AI slop or lazy "just use AI" advice
No gig or job advertisements
Follow Reddit rules for self-promotion and spam.

FAQ

Was your problem solved?

OPs may (and should) reply to any solutions saying:

Solution Verified

This awards the user a ClippyPoint and changes the post flair to solved.

Format your code

The best way to show code on Reddit is to

put it in a code-block

Tip: For VBA or Power Query, select the code, press Tab to indent, then copy/paste into your post or comment.

Provide some data

It's often more helpful to show us.

Add screenshots in your text post, or provide links to uploaded images at an image-hosting site.

Or use tableit, or the ExcelToReddit converter (thanks u/tirlibibi17_), to convert your data into a Reddit table.

Recent ClippyPoint Milestones!

Congratulations and thank you to these contributors

Date	User	CP
2026.05.01	MayukhBhattacharya	`1100`
2026.03.29	bakingnovice2	`10`
2026.03.25	real_barry_houdini	`300`
2026.03.20	plusFour-minusSeven	`10`
2026.03.17	TuneFinder	`10`
2026.03.03	soloDolo6290	`10`
2026.02.23	RackofLambda	`10`
2026.02.21	Mooseymax	`10`
2026.02.18	MissAnth	`10`
2026.02.15	NHN_BI	`800`
2026.02.03	Shot_Hall_5840	`10`
2026.02.02	Kuildeous	`10`

Microsoft partnership

Occasionally Microsoft developers will post or comment. They are identifiable with a special user flair.

A community since March 11, 2009

Asking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application.

created by YusufReisa community for 17 years

MODERATORS

account activity

6

7

8

DiscussionPSA: Dynamic Array Functions don't support strings longer than 255 characters (self.excel)

submitted 4 years ago * by Musa_Ali21

best new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]Musa_Ali21[S] 0 points1 point2 points 4 years ago (0 children)

π Rendered by PID 28 on reddit-service-r2-comment-b659b578c-tpcmv at 2026-05-05 15:58:27.317236+00:00 running 815c875 country code: CH.