Convert Text To Columns Shortcut - Excel 2010

Johnny Thunder

Johnny Thunder

Well-known Member
Joined
Apr 9, 2010
Messages
693
Office Version
  1. 2016
Platform
  1. MacOS
I was wondering if there is a shortcut to run "Convert text to Columns"

Using ALT+A+E+W+N gets you to the data preview that has a ruler, the part I need the shortcut for would be to get the ruler to the 10 mark without using the mouse? Any help would be appreciated. Thanks
 
Last edited:

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Johnny

The only way to set the breaks is by clicking the mouse.
 
Upvote 0
But I was really good this year and I always eat all my vegtables and I only had one cavity all year..... come on!! There just has to be......LOL
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
VBA Check for duplicate value and change if duplicate.
Replies
7
Views
113
Alex Blakenburg
A
E
  • Locked
  • Question
Data filters
Replies
2
Views
463
Fluff
Fluff
R
  • Question
How to change DATE format without using =UPPER(TEXT("22-04-2010","ddmmmyy")
Replies
9
Views
299
RapchikM
R
E
  • Question
Data Filtering – Help needed with some nervous Excel users!
Replies
9
Views
801
Peter_SSs
Peter_SSs
A
  • Solved
Converting text to date but 29 feb won't show, instead it shows 1 Mar
Replies
5
Views
214
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,216,099
Messages
6,128,822
Members
449,469
Latest member
Kingwi11y

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top