software

ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF quot;flip floppingquot; names in a
list, from last, first to first last? (maybe quot;tellingquot;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 Datagt;Text-to-Columns
Set the delimiters to comma and space

That should break the text into 2 columns.

Does that help?

***********
Regards,
Ronquot;RenieFoquot; wrote:

gt; ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF quot;flip floppingquot; names in a
gt; list, from last, first to first last? (maybe quot;tellingquot;the list to separate
gt; into 2 columns the words separated by the comma, last in one column and first
gt; in another). I have a list of 360 names and not looking forward to cut and
gt; paste this list. HELP!


You could use this in the cell to the right of your name. Drag down the
list of 360.

=RIGHT(A1,LEN(A1)-1-FIND(quot;,quot;,A1))amp;quot;,quot;amp;LEFT(A1,FIND(quot;,quot;,A1)-1)

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=493420
If you want to remove the comma between the names then.=RIGHT(A1,LEN(A1)-1-FIND(quot;,quot;,A1))amp;quot; quot;amp;LEFT(A1,FIND(quot;,quot;,A1)-1)

The amp; quot; quot; creates a space between first and last names. I had a quot;,quot;
there in the last example.HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=493420THANK 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!!

quot;Ron Coderrequot; wrote:

gt; See if this works for you...
gt; Try Datagt;Text-to-Columns
gt; Set the delimiters to comma and space
gt;
gt; That should break the text into 2 columns.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt;
gt; quot;RenieFoquot; wrote:
gt;
gt; gt; ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF quot;flip floppingquot; names in a
gt; gt; list, from last, first to first last? (maybe quot;tellingquot;the list to separate
gt; gt; into 2 columns the words separated by the comma, last in one column and first
gt; gt; in another). I have a list of 360 names and not looking forward to cut and
gt; gt; paste this list. HELP!

I'm glad I could help.

Enjoy the holidays.

***********
Regards,
Ronquot;RenieFoquot; wrote:

gt; THANK YOU SO MUCH, THIS WAS A LIFE SAVER!! I KNEW THERE HAD TO BE A WAY,
gt; EXCEL CAN DO A N Y T H I N G !! Thanks all for your assistance, I'm telling
gt; my friends about this website. Again, you're a life saver. MERRY CHRISTMAS!!
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; See if this works for you...
gt; gt; Try Datagt;Text-to-Columns
gt; gt; Set the delimiters to comma and space
gt; gt;
gt; gt; That should break the text into 2 columns.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt;
gt; gt; quot;RenieFoquot; wrote:
gt; gt;
gt; gt; gt; ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF quot;flip floppingquot; names in a
gt; gt; gt; list, from last, first to first last? (maybe quot;tellingquot;the list to separate
gt; gt; gt; into 2 columns the words separated by the comma, last in one column and first
gt; gt; gt; in another). I have a list of 360 names and not looking forward to cut and
gt; gt; gt; paste this list. HELP!


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'--
nerdman
------------------------------------------------------------------------
nerdman's Profile: www.excelforum.com/member.php...oamp;userid=29614
View this thread: www.excelforum.com/showthread...hreadid=493420
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 in
B1

=IF(A1=5,quot;Yesquot;,quot;quot;)Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=493420
The rounding will go up if the value is a decimal value from say 3.5 to
4.0 and go down if it is 3.0 to 3.4999999. If you always want to round
up, change the ROUND in my example to ROUNDUP or to round down,
ROUNDDOWN.Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=493420
Youre unbelievable!!!--
nerdman
------------------------------------------------------------------------
nerdman's Profile: www.excelforum.com/member.php...oamp;userid=29614
View this thread: www.excelforum.com/showthread...hreadid=493420