How do I format list of names formatted last,first to first last?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF "flip flopping" names in a
list, from last, first to first last? (maybe "telling"the list to separate
into 2 columns the words separated by the comma, last in one column and first
in another). I have a list of 360 names and not looking forward to cut and
paste this list. HELP!
 
See if this works for you...
Try Data>Text-to-Columns
Set the delimiters to comma and space

That should break the text into 2 columns.

Does that help?

***********
Regards,
Ron
 
You could use this in the cell to the right of your name. Drag down th
list of 360.

=RIGHT(A1,LEN(A1)-1-FIND(",",A1))&","&LEFT(A1,FIND(",",A1)-1)

Cheers,

Stev
 
If you want to remove the comma between the names then.


=RIGHT(A1,LEN(A1)-1-FIND(",",A1))&" "&LEFT(A1,FIND(",",A1)-1)

The & " " creates a space between first and last names. I had a ",
there in the last example.


HTH

Stev
 
THANK YOU SO MUCH, THIS WAS A LIFE SAVER!! I KNEW THERE HAD TO BE A WAY,
EXCEL CAN DO A N Y T H I N G !! Thanks all for your assistance, I'm telling
my friends about this website. Again, you're a life saver. MERRY CHRISTMAS!!
 
Problem two: the thing is im making a grade application this means that
the Average has to be counted out BUT the average for example 4.5 has
to automatically change into 4+ or 3.95 has to change into 4 you get
it? Sorry i didnt explain the full problem.

Problem three: unrelated but when i have a 5 in one cell id like in a
nother cell to show up the word 'yesss' or any other word just as an
example...

thanks yet again you are so helpful i cant believe i never asked any
questions here

'bow to the masters of excel'
 
To round your average.

=ROUND(AVERAGE(P1:P26),0) - Wher P1:P26 are your numbers to average.

To return a Yes in cell B1 if the value in say cell A1 is = 5 then i
B1

=IF(A1=5,"Yes","")


Cheers,

Stev
 
The rounding will go up if the value is a decimal value from say 3.5 t
4.0 and go down if it is 3.0 to 3.4999999. If you always want to roun
up, change the ROUND in my example to ROUNDUP or to round down
ROUNDDOWN.


Stev
 
Another problem!

I have a row of cells with choice lists (4 choices) and at the end
want it to count the number of each choice! Im not sure how to deal
with this ! Thanx ! Sorry for the amount of questions im just learnin
excel
 
In the 4 columns to the right of your end point, type in the 4 choices
say in cells G1:J1. Then in cell G2 use

=COUNTIF($A$2:$F$2,G1)

Drag this across to cell J2. This will summarize the count of each of
the choices as shown in cells G1:J1.

Cheers,

Steve
 
SteveG said:
To round your average.

=ROUND(AVERAGE(P1:P26),0) - Wher P1:P26 are your numbers to average.

To return a Yes in cell B1 if the value in say cell A1 is = 5 then i
B1

=IF(A1=5,"Yes","")


Cheers,

Steve

back to this one: i have 6 numbers 1-6 each needs a word - one-six let
make it
now i understand how to make the IF but how to make a couple fof IF'
in one FUnction! Again Thanx!
 
I think this is what you are asking for.

In cell B6;

=IF(OR(A6>6,A6<=0),"",IF(A6>0,CHOOSE(A6,"Test 1", "Test 2", "Test 3",
"Test 4", "Test 5", "Test 6")))

A6 is where your values from 1-6 are. The first step returns a blank
cell if the number in A6 is greater than 6 or less than/equal to 0.
The second IF looks at the value in A6 and uses the CHOOSE function to
assign values in ascending order 1-6. Meaning, the CHOOSE looks at A6
and if the value is 1 then it returns "Test 1" (this is where you
assign your words to the corresponding values), if the value is 2 then
"Test 2" and so on....

HTH

Cheers,

Steve
 
Back
Top