My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Row does not text wrap in Power Query after loading|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Row does not text wrap in Power Query after loading|Power Query|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Row does not text wrap in Power Query after loading
Avatar
Kenneth McMillan
USA
Member
Members

Dashboards

Power Query
Level 0
Forum Posts: 29
Member Since:
November 15, 2017
sp_UserOfflineSmall Offline
1
January 27, 2018 - 9:04 am
sp_Permalink sp_Print

I am making a table with Windows Character List. After making some edits using Power Query and load to a table, for some reason the text in row in row #11 does not wrap after loading to a table. Can someone please tell me what I am doing wrong.
Please see attached file.
Thanks so much,

Ken Mc

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4515
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
January 27, 2018 - 12:56 pm
sp_Permalink sp_Print

Hi Ken,

Character 10 requires the Wrap Text cell format to be applied for it to actually wrap. If you format the cells with Wrap Text the wrapping appears.

Mynda

Avatar
Kenneth McMillan
USA
Member
Members

Dashboards

Power Query
Level 0
Forum Posts: 29
Member Since:
November 15, 2017
sp_UserOfflineSmall Offline
3
January 28, 2018 - 12:56 am
sp_Permalink sp_Print

Thanks Mynda. How stupid of me not to think about that. Sometimes you try to fix a problem and it's right in front of you.

You're the best!
Thanks again,

Ken Mc

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kelly Andrews
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
Forum Stats:
Groups: 3
Forums: 24
Topics: 6359
Posts: 27806

 

Member Stats:
Guest Posters: 49
Members: 32336
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen