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 |
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 |
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 |
All times are GMT +1. The time now is 11:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com