Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HelpNeed to know what formulas I need to use to move names in a co
Working with a data base that has names in a column as follows:
Smith James & Sara or Jones Sam R & Mary J and I need them to read James & Sara Smith and/or Sam R & Mary J Jones can someone tell me the formulas I need to use in order to accomplish this or where I can find help in Microsoft office to accomplish this. Thank you in advance for any assistance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HelpNeed to know what formulas I need to use to move names in a co
This works with your two example (name in A1)
=MID(A1,FIND(" ",A1)+1,255)&" "&LEFT(A1,FIND(" ",A1)-1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Help Me - I need to switch these names" ft.com wrote in message ... Working with a data base that has names in a column as follows: Smith James & Sara or Jones Sam R & Mary J and I need them to read James & Sara Smith and/or Sam R & Mary J Jones can someone tell me the formulas I need to use in order to accomplish this or where I can find help in Microsoft office to accomplish this. Thank you in advance for any assistance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HelpNeed to know what formulas I need to use to move names in a co
Hi,
If the names are in A1:A100, enter the following formula in row 1 of a helper column (e.g., B1) and auto-fill to the last row. =MID(A1,FIND(" ",A1)+1,120)&" "&LEFT(A1,FIND(" ",A1)-1) Regards, B. R. Ramachandran "Help Me - I need to switch these names" wrote: Working with a data base that has names in a column as follows: Smith James & Sara or Jones Sam R & Mary J and I need them to read James & Sara Smith and/or Sam R & Mary J Jones can someone tell me the formulas I need to use in order to accomplish this or where I can find help in Microsoft office to accomplish this. Thank you in advance for any assistance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you move names and data between large Excel 2003 workbooks? | Excel Worksheet Functions | |||
USING NAMES IN FORMULAS | Excel Worksheet Functions | |||
replacing just the sheet names within formulas | Excel Worksheet Functions | |||
Locking Sheet names in formulas | Excel Worksheet Functions | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |