Formula to sort text

D

DrBob

New Member
Joined
Jun 25, 2008
Messages
28
Hi everyone.

I'm trying to find a formula that will automatically sort a 2 columns (surnames and forenames).

The surname is in column A, forename in column B. I want the sorted list to appear in columns C and D. Is this possible? Thanks in anticipation.
 
Sort by date Sort by votes

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

N
  • Question
XLOOKUP/INDEX MATCH spills down but not right
Replies
4
Views
181
Alex Blakenburg
A
G
  • Solved
Return Cell references of specific text in range
2
Replies
19
Views
311
smozgur
smozgur
L
  • Question
Draw data from website
Replies
2
Views
96
Lux Aeterna
L
K
  • Question
Sync AutoFilter between 2 Tables on same Worksheet
Replies
1
Views
138
John_w
J
P
  • Question
VBA Code Error
Replies
3
Views
279
dreid1011
dreid1011

Forum statistics

Threads
1,215,417
Messages
6,124,787
Members
449,188
Latest member
Hoffk036

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