[Affiliate]
Blog Stats
- 3,324,402 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Sequential number for visible rows only
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Advanced vlookup - wildcard characters "?" and "*"
- Extract part of text string with delimiter(s)... and more with Text to Columns
- Copy data from strictly-protected sheet
- Bug with copy and paste in Excel Table
- About
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Split Cell
Split date ranges from cells with #Excel #PowerQuery
Take a look at the challenge presented above. Is it possible to do it in Excel? Be honest, without Power Query, I have no idea how to do it but manual work. 😁🤦♂️ Believe it or not, with Power Query, … Continue reading
Split cell contents separated by line feed into rows with #Excel #PowerQuery – Part 2
Last week, I showed you how to split cell contents separated by line feed into rows with Power Query. That was easy when we are dealing with only one column. If you don’t know how, you may read the post … Continue reading
Split cell contents separated by line feed into rows with #Excel #PowerQuery
After an in-house training, a colleague came to me and asked if there is a way to do the following: The problem here is the contents in cells are separated by a line feed (line break). A cell may contain … Continue reading



