Home Events - Excel Campus Members Area Live QA Meeting for Elevate – August 2023
Live QA Meetings

Live QA Meeting for Elevate – August 2023

Get your Excel-related questions answered during our monthly live Q&A meeting.


Download Example Files

The event is finished.

Date

Aug 24 2023
Expired!

Time

10:00 am - 11:00 am

Local Time

  • Timezone: America/New_York
  • Date: Aug 24 2023
  • Time: 1:00 pm - 2:00 pm
Category

Organizer

Jon Acampora
Jon Acampora

Responses

  1. Using Power Query I first made a duplicate Category Item column and then was able to use ‘Replace Values” to remove the extra spaces (i.e.; Electric Bikes Super Commuter+) to make the Category Item (i.e.; ElectricBikes Super Commuter+). Then I was able to split the columns by the left space delimiter. Finally, I could use ‘Replace Values’ to add the space back in for the new Category column. Close & Load and the data was perfect!