This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
| MAY,AUG,NOV,FEB | MAY or AUG or NOV or FEB | ||
|---|---|---|---|
How to split text in A1 in cell B1 before first deli meter "," after 1st deli meter and before 2nd deli meter split data in cell B2. formula should return any one value MAY or AUG or NOV OR FEB using single function.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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
=INDEX(TEXTSPLIT(A1,","),2)
You can change 2 to 1,2,3,4 to get May,Aug,Nov, or Feb.
If I need MAY what will be the formula in B1,If for AUG what will be formula in cellB1,if for NOV what will be the formula and if for FEB what is the formula
