| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format list of names formatted last,first to first last?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
See if this works for you...
Try DataText-to-Columns Set the delimiters to comma and space That should break the text into 2 columns. Does that help? *********** Regards, Ron "RenieFo" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first la
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!! "Ron Coderre" wrote: See if this works for you... Try DataText-to-Columns Set the delimiters to comma and space That should break the text into 2 columns. Does that help? *********** Regards, Ron "RenieFo" wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first la
I'm glad I could help.
Enjoy the holidays. *********** Regards, Ron "RenieFo" wrote: 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!! "Ron Coderre" wrote: See if this works for you... Try DataText-to-Columns Set the delimiters to comma and space That should break the text into 2 columns. Does that help? *********** Regards, Ron "RenieFo" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
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(",",A1))&","&LEFT(A1,FIND(",",A1)-1) Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
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 Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
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: http://www.excelforum.com/member.php...o&userid=29614 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
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,"Yes","") Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
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: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
Youre unbelievable!!! -- nerdman ------------------------------------------------------------------------ nerdman's Profile: http://www.excelforum.com/member.php...o&userid=29614 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
Another problem! I have a row of cells with choice lists (4 choices) and at the end i want it to count the number of each choice! Im not sure how to deall with this ! Thanx ! Sorry for the amount of questions im just learning excel! -- nerdman ------------------------------------------------------------------------ nerdman's Profile: http://www.excelforum.com/member.php...o&userid=29614 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
SteveG Wrote: 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,"Yes","") Cheers, Steve back to this one: i have 6 numbers 1-6 each needs a word - one-six lets make it now i understand how to make the IF but how to make a couple fof IF's in one FUnction! Again Thanx!! -- nerdman ------------------------------------------------------------------------ nerdman's Profile: http://www.excelforum.com/member.php...o&userid=29614 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format list of names formatted last,first to first last?
I think this is what you are asking for. In cell B6; =IF(OR(A66,A6<=0),"",IF(A60,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 -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=493420 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| How do I import a list of names into a separate form that prints . | Excel Worksheet Functions | |||
| How do I create/filter a list of names without duplications | Excel Discussion (Misc queries) | |||
| How do I find a name in a list of names? | Excel Worksheet Functions | |||
| List of repeating names | Excel Worksheet Functions | |||
Hybrid Mode
