Get instant live expert help on I need help with longest common prefix

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I wanted to create a formula with my own prefix followed by value of cell. Eg: if my prefix was B. =B(cell value of J5)
Solved by O. J. in 30 mins
I have a problem regarding to Find longest string in column
Solved by F. Y. in 11 mins
I need to create a formula that extracts the prefix from column A
Solved by I. Q. in 15 mins
I need to pull One Code(Text) from 4 available Codes(Texts, e.g. MOSC, MORE, SYFF, WAE22 etc.) based on following criteria: -If Code has "MO" in it choose the longest one without "MO" - Always choose the longest one
Solved by E. D. in 29 mins
Hi, i need to calculate the longest, current and average win and loss streaks.
Solved by G. A. in 21 mins