Excel text to columns feature

		Microsoft Office Forums > Microsoft Excel > Excel
Excel text to columns feature

FAQ

Thread Tools

Display Modes

08-17-2024, 04:30 AM

Alansidman Alansidman is offline

Windows 11 Excel text to columns feature

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

if you use Power Query in the User Interface the em dash is automatically identified in this Mcode

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter("—", QuoteStyle.Csv), {"Column1.1", "Column1.2"})
in
    #"Split Column by Delimiter"

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't find text box feature for entering text in a form in command list.	Mo Mentum	Word	2	11-08-2023 08:32 AM
Warping Text Feature	Craiger	Publisher	0	10-19-2018 02:15 PM
Sum to include (-)/ Text feature	Haha88	Excel	4	10-11-2017 02:55 PM
Excel feature for Word	YooNaa Kim	Word	2	01-28-2011 11:50 AM
Getting Plain Text into Excel Columns	binar	Excel	1	11-05-2010 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 PM.