How to Avoid the 255 Character Limit in Excel Formulas : Microsoft Excel Tips

Subscribe Now:

Watch More:

There are a number of interesting tricks that you can use to cleverly avoid the 255 character limit in Microsoft Excel. Avoid the 255 character limit in Excel with help from a mechanical engineer with 32 years of experience in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel is a powerful database and spreadsheet tool that is an important part of the Microsoft Office productivity suite of software. Get tips on how to best use Microsoft Excel to its full potential with help from a mechanical engineer with 32 years of experience in this free video series.

[sccarrico]

This is a valuable public service, thank you for posting this educational / training video.

[ΛούλοςΑχιλλέας]

That's not a solution. Shame to you "32 years experience"

[pradhapmoorthy]

this is for simple arithmetic. but how to do for if conditions

[marlysbaldezamo]

This is not the same in my case..Mine is I have a formula countif because I want to count how many times a specific string data exists in column E range...That specific string data comes from concatenate formula with more than 255 characters..Then the output is number value which is error...but if Im going to reduce the number of characters to below 256 in the source of concatenate formula it wont generate error...Anyone pls help...thanks

[chrisjako]

this resolution is not appropriate for my issue

[richardtriance]

missed the ball completely on this, didn't ya ?