|
|
|
|
|
|
Welcome to the Australian Ford Forums forum. You are currently viewing our boards as a guest which gives you limited access to view most discussions and inserts advertising. By joining our free community you will have access to post topics, communicate privately with other members, respond to polls, upload content and access many other special features without post based advertising banners. Registration is simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. Please Note: All new registrations go through a manual approval queue to keep spammers out. This is checked twice each day so there will be a delay before your registration is activated. |
|
|||||||
| The Bar For non Automotive Related Chat |
 |
|
|
Thread Tools | Display Modes |
21-05-2020, 05:15 PM
|
#1 | ||
|
FF.Com.Au Hardcore
Join Date: Jun 2011
Location: Pt Lincoln far side South Oz
Posts: 5,637
|
being a goose at computers, this could be dangerous but...
have a copy of excell database email addresses and its all over the place like hookers knickers. I was given this as part of my job. 1st column.,. first names (mostly) 2nd column Surnames but no order Can I swap columns around and also get surnames into alphabetical order.
__________________
Dont p i s s off older people. At our age the term Life in Prison is not a deterrent |
||
|
|
|
21-05-2020, 05:23 PM
|
#2 | ||
|
Regular Member
Join Date: Feb 2011
Posts: 282
|
Highlight all the cells (including column headers....eg Name, Address etc)
Then look at top of screen and you will find Sort & Filter Filter You will then be able to click on the Headers and sort in alphabetical order.
__________________
2013 FPV GT (Sold) 2015 Renault Megane RS265 - 2L Turbo 6Spd Manual 2022 (21.75) Ford Everest Bi-Turbo |
||
|
|
|
|
21-05-2020, 05:47 PM
|
#3 | ||
|
FF.Com.Au Hardcore
Join Date: Jun 2011
Location: Pt Lincoln far side South Oz
Posts: 5,637
|
cheers mate all good
__________________
Dont p i s s off older people. At our age the term Life in Prison is not a deterrent |
||
|
|
|
|
21-05-2020, 06:40 PM
|
#4 | ||
|
Regular Member
Join Date: Feb 2011
Posts: 282
|
No worries
__________________
2013 FPV GT (Sold) 2015 Renault Megane RS265 - 2L Turbo 6Spd Manual 2022 (21.75) Ford Everest Bi-Turbo |
||
|
|
|
|
22-05-2020, 11:30 AM
|
#5 | |||
|
Donating Member
 
Join Date: Mar 2007
Location: Heading thru Hell (Corner)
Posts: 7,927
|
Quote:
To move the columns, highlight the column (click on the column letter, and the entire column should become greyed out). Right click, cut. Highlight (click on column letter) the column to the right of where you want to place the cut column, right click and select 'Insert cut cells'. Hope that helps.
__________________
Labels are for jars, not for people. Life is a journey, not a destination. ~~~~~~~~~~~~~~ Daily: 2013 FGII EcoLPi in Winter White Play: 2015 FG X XR8 in Emperor Show' N Shine thread Gone, but not forgotten: 2015 SZII petrol Titanium Territory in Emperor |
|||
|
|
|
|
22-05-2020, 01:03 PM
|
#6 | ||
|
Regular Member
Join Date: Oct 2009
Posts: 410
|
and if you want to join them together type into C1 the formula as below
A B C 1 John Smith =A1&" "&B1 (enter to get John Smith) Just sayin' doesnt space out as i posted but in a1 is John , b1 is Smith , c1 is the formula above |
||
|
|
|
|
22-05-2020, 01:14 PM
|
#7 | ||
|
Regular Member
Join Date: Oct 2009
Posts: 410
|
to sort not filter
highlight whole sheet (the square to the left of A and above row 1 highlights the whole sheet) go to data on menu bar sort (not the a-z option) go to drop down sort by choose column you want sorted - then either a to z or z to a enter and boom Last edited by MustangStevo63; 22-05-2020 at 01:22 PM. |
||
|
|
|
| This user likes this post: |
|
22-05-2020, 07:04 PM
|
#8 | ||
|
FF.Com.Au Hardcore
Join Date: Jun 2011
Location: Pt Lincoln far side South Oz
Posts: 5,637
|
cheers guys all sorted...enough for me anyway.
__________________
Dont p i s s off older people. At our age the term Life in Prison is not a deterrent |
||
|
|
|
| This user likes this post: |
|
| Thread Tools | |
| Display Modes | |
|
|
Excell question
Linear Mode
