Register
Log In
Unanswered
Home
New Member
February 21, 2017
Offline
I would like to use split on 1 column into 4. There are about 50 spaces before the first string. How to use in power Query?
Is there a "Treat consecutive delimiters as one" feature or formula?
Thanks in advance.
July 16, 2010
Online
No, there isn't the same 'Treat consecutive delimiters as one' feature that we have in Excel, but you can first split by a fixed width to get rid of the blank spaces at the beginning of the string.
Mynda
Most Users Ever Online: 57
Currently Online: Mynda Treacy
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
