Text Split in Excel: Polish Menus and Methods

How-to basics · Updated November 18, 2026

To split text in Excel with Polish menus, select the cells, then choose Dane > Tekst jako kolumny (Data > Text to Columns), pick a delimiter such as a comma or space, preview the result, and finish. For a formula-based split that updates when the source changes, Microsoft 365 and Excel 2024 also offer TEXTSPLIT; the function name and argument separator may appear differently in a Polish-language installation.

What “text split” means in Excel

Splitting text means taking one cell that contains several pieces of information and distributing those pieces into separate cells. For example, a cell containing Nowak, Anna, 104 could become three cells: Nowak, Anna, and 104. This is useful when importing contact lists, cleaning copied data, separating product codes, or making a column easier to sort and filter.

The best method depends on how the text is arranged. A comma-separated list has a clear delimiter, so Excel can split at each comma. A fixed-width code, by contrast, may need to be divided after a certain number of characters. If each row follows a different pattern, an automatic split may not be reliable; it can be better to clean the source first or use Power Query with explicit transformation steps.

Splitting is not the same as converting text that looks like a number into a numeric value. After a split, a result such as 00127 may remain text or may be interpreted as a number, depending on the method and column settings. That distinction matters when leading zeroes are part of an ID or postal code.

Use Text to Columns in Polish Excel

Text to Columns is a convenient choice for a one-time split of existing data. In Excel for Microsoft 365 on Windows, open the Dane tab and choose Tekst jako kolumny. In the wizard, select the option that matches the data, set the delimiter or column break, review the preview, and complete the operation. The exact Polish wording can vary slightly by Office version, but the command is on the Data tab.

  1. Select the source cells in one column. Leave adjacent columns empty so the results have room to spill across; otherwise, Excel may overwrite existing content or warn that the destination is occupied.
  2. Choose the delimited option when a character such as a comma, tab, semicolon, or space separates the parts. Choose fixed width when the break is based on character positions rather than a separator.
  3. For delimited data, select the appropriate delimiter and inspect the preview. If the data uses a character not listed, choose the option for another delimiter and enter it.
  4. Set the destination if you do not want to replace the source column. Use the preview to check where each value will land, then finish.

For example, a tab-separated list copied from a report can often be split by choosing the tab delimiter. A column containing Lee;Morgan;7 needs a semicolon delimiter, not a comma. Choosing the wrong separator can leave everything in one column or divide values in unexpected places. Text to Columns changes the selected data in place unless you specify another destination, so save a copy or use a spare column if the original must be preserved.

Choosing the right delimiter

A delimiter is the character or sequence that marks the boundary between pieces. Common choices include commas, tabs, semicolons, spaces, and slashes. Look at several rows before choosing: a comma may separate fields in one dataset but also appear inside a quoted address or description. The wizard has a text qualifier setting for some delimited formats, which helps keep delimiters inside quoted text together. Check the preview rather than assuming that every comma is a true boundary.

Polish regional settings can make imported data confusing. A comma is commonly used as a decimal mark in Polish-formatted numbers, while a semicolon may separate fields in a CSV file. This does not mean semicolon is always the right split character: use the delimiter that actually separates the fields in the source. If a file came from another system, inspect a few raw lines or use Excel’s import preview before changing anything.

  • Use a comma or semicolon only when that exact character separates the values in the source.
  • Use a tab for data copied from many tables and reports.
  • Use a space only when spaces reliably mark boundaries. Names and addresses often contain internal spaces, so splitting on every space can create too many columns.
  • Use fixed width when positions are consistent, such as a code whose first four characters always represent a region.

Split text with TEXTSPLIT

For a repeatable split that recalculates when the source cell changes, use TEXTSPLIT in Microsoft 365 or Excel 2024. It returns a dynamic array, so the results fill neighboring cells automatically. The formula examples here use English function names and comma argument separators. A Polish installation may display a localized function name and may use semicolons between arguments, depending on its language and regional settings; use Excel’s formula autocomplete to see the syntax accepted by your copy.

With the full text Nowak, Anna, 104 in cell A2, enter =TEXTSPLIT(A2,", ") in an empty cell. It splits at each comma followed by a space. The result is Nowak, Anna, and 104 across three cells in the same row. The formula will not place the results on top of the source; leave enough empty cells to the right for the array.

With a list in A2 that uses commas without a following space, enter =TEXTSPLIT(A2,","). For the input red,blue,green, the result is red, blue, and green. If the source is red, blue, green, splitting only on the comma leaves a leading space before the second and third items. Using comma-plus-space as the delimiter avoids that when the source is consistent. TEXTSPLIT can also use a row delimiter to return results vertically, but the delimiter must match the characters present in the text.

Dynamic-array formulas cannot spill into cells that already contain values, and a blocked result produces a spill error. Clear the cells in the intended output area or move the formula. If you need a permanent, one-time result, copy the spilled cells and use Paste Special > Values to replace formulas with their current results.

Fixed-width splits and imported files

Fixed-width splitting is appropriate when each record has fields in predictable character positions. Imagine records where the first three characters are a department code, the next six are a date, and the remaining characters are a reference. In Text to Columns, choose fixed width and adjust the break markers in the preview. This method does not infer meaning; a shifted character in one row can put later values into the wrong columns.

When opening a CSV or text file, consider importing it rather than opening it directly if Excel guesses the wrong columns, date format, or number type. On Windows, use Dane > Z tekstu/CSV (Data > From Text/CSV) where available, review the preview and import settings, and load the data after checking the result. This is especially important for identifiers with leading zeroes and dates that could be interpreted differently across regional settings. Excel for the web has fewer import and transformation controls than desktop Excel, so the exact workflow may differ.

On Mac, the Data tab also provides text-splitting tools, though labels and dialog layouts can differ from Windows. In Excel for the web, feature availability and menus can vary; if Text to Columns is not available in the current interface, open the workbook in the desktop app or use a supported formula. Always check that the output has the intended number of columns before using it in another process.

Alternatives for repeated cleanup

Text to Columns is fast for a single cleanup, while a formula or Power Query is usually more suitable when the same transformation must be repeated. Choose based on whether the source changes and how many files or rows need processing.

  • TEXTSPLIT: good for a live result based on a consistent delimiter. It recalculates from the source, but requires Microsoft 365 or Excel 2024 and enough blank space for its results.
  • Power Query: useful for importing and cleaning recurring files. In Excel for Microsoft 365 on Windows, use Dane > Pobierz dane or the relevant import command, then use the query editor’s split-column options. Refresh the query when the source changes. The available buttons may differ by platform.
  • Flash Fill: useful when Excel can recognize a pattern from examples you type beside the source. Enter the intended first result, start the next example, and use Dane > Wypełnianie błyskawiczne if the command is available. Review every row: pattern recognition can fail when names or formats vary.
  • Manual editing: reasonable for a very small list, but difficult to audit and repeat. Keep an untouched copy of the source if accuracy matters.

Common problems and how to fix them

If the split goes into only one column, the selected delimiter may not match the source, or the separator may be hidden whitespace rather than a normal space. Inspect a sample and try the correct delimiter. If a value breaks into too many pieces, the delimiter may also occur inside the data; use a text qualifier where appropriate, choose a more specific delimiter, or clean the source first.

If values appear to lose leading zeroes, Excel may have treated them as numbers. For IDs, postal codes, or product codes, preserve the output as text: use the wizard’s column data format option when suitable, or import the source with its column type set to text. Do not rely on a custom number display alone if the underlying value must remain an identifier.

If a split formula returns an error, confirm the function is supported in that Excel version, the delimiter is present, and the output cells are empty. In a Polish locale, check the function spelling and whether the formula separator should be a semicolon rather than a comma. If the result contains unwanted spaces, adjust the delimiter or clean the split results; trimming every value may be useful, but it should not remove meaningful spaces inside names or phrases.

Frequently Asked Questions

How do I split one cell into two columns in Polish Excel?
Select the cell or column, choose Dane > Tekst jako kolumny, select the delimiter that separates the two parts, check the preview, and finish. Make sure the column beside the source is empty.

What is Text to Columns called in Polish Excel?
The command is generally labelled Tekst jako kolumny on the Dane tab. Wording or placement can vary slightly by version, but it is the Data tab’s text-splitting wizard.

Can I split text automatically when the source changes?
Yes. In Microsoft 365 or Excel 2024, TEXTSPLIT can return a dynamic array that updates when its source cell changes. Its localized name and argument separators may differ in Polish Excel.

Why does Excel split Polish CSV data incorrectly?
The file’s delimiter, decimal mark, encoding, or date format may not match Excel’s assumptions. Preview the import, choose the separator actually used in the file, and check number and date columns before loading.

Can I split a name by spaces?
You can, but splitting at every space may separate first, middle, and last names into extra columns and may not handle compound names consistently. If you need only first and last names, confirm the source follows a consistent format before choosing a space delimiter.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.