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

[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!

 

[Guest]

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

 

[SteveG]

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

 

[SteveG]

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

 

[Guest]

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!!

 

[Guest]

I'm glad I could help.

Enjoy the holidays.

***********
Regards,
Ron

 

[nerdman]

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'

 

[SteveG]

To round your average.

=ROUND(AVERAGE(P126),0) - Wher P126 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

 

[SteveG]

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

 

[nerdman]

Youre unbelievable!!!

 

[nerdman]

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

 

[SteveG]

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

 

[nerdman]

To round your average.

=ROUND(AVERAGE(P126),0) - Wher P126 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!

 

[SteveG]

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