Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flip/Flop
Hi,
I'm working with Excel 2003. I have a column that contains First Name, space, Last name. I need it to contain Last Name, comma, space, First name. I've searched through the other questions/answers and tried a few things myself (like Text to columns) with no luck. Is there anyway this can be done other than retyping?? I can create a new column to hold the data and then delete the old one if necessary, I just need to fix about 1100 rows and then from there I will enter it the correct way in the first place. Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flip/Flop
Hi Angie,
If cell A1 contains "Red Ferrari" this formula will return "Ferrari, Red" =RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1)-1) Ed Ferrero |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flip/Flop
Thanks, that worked perfectly! I just realized that I need to turn the
result of the formula into text now, so I will create another blank column to the right and convert the results of the formula into text. How do I do that?? Thanks again, Ed. "Ed Ferrero" wrote: Hi Angie, If cell A1 contains "Red Ferrari" this formula will return "Ferrari, Red" =RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1)-1) Ed Ferrero . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flip/Flop
Hi Angie,
Thanks, that worked perfectly! I just realized that I need to turn the result of the formula into text now, so I will create another blank column to the right and convert the results of the formula into text. How do I do that?? The formula does return text. If you want Text in a cell instead of a formula, Copy, Paste Special, Values. Ed Ferrero www.edferrero.com |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flip/Flop
Great, that worked! Thanks again
"Ed Ferrero" wrote: Hi Angie, Thanks, that worked perfectly! I just realized that I need to turn the result of the formula into text now, so I will create another blank column to the right and convert the results of the formula into text. How do I do that?? The formula does return text. If you want Text in a cell instead of a formula, Copy, Paste Special, Values. Ed Ferrero www.edferrero.com . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create logic functions like a flip-flop in excel? | Excel Discussion (Misc queries) | |||
flip table | Excel Discussion (Misc queries) | |||
Reverse a "row" of numbers (flip flop them)? | New Users to Excel | |||
How do I flip a bar chart? | Charts and Charting in Excel | |||
hOW DO i FLIP THE X AND Y AXIS | Charts and Charting in Excel |