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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
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

E
  • Locked
  • Question
Data filters
Replies
2
Views
432
Fluff
Fluff
R
  • Question
How to change DATE format without using =UPPER(TEXT("22-04-2010","ddmmmyy")
Replies
9
Views
249
RapchikM
R
E
  • Question
Data Filtering – Help needed with some nervous Excel users!
Replies
9
Views
748
Peter_SSs
Peter_SSs
A
  • Solved
Converting text to date but 29 feb won't show, instead it shows 1 Mar
Replies
5
Views
170
Peter_SSs
Peter_SSs
I
  • Question
Text to columns Fixed With merging two columns with a decimal
Replies
2
Views
58
ItalianPlatinum
I

Forum statistics

Threads
1,214,788
Messages
6,121,603
Members
449,038
Latest member
Arbind kumar

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