| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change data in a single column from "last, first" to "first last"
H Jeanne,
If you Names are in Column A, and the last and first are separated by a "," then: In column B, you could put: =MID(A1,FIND(",",A1)+2,LEN(A1)-(FIND(",",A1)+1)) Hope this helps. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
| Index Row and return data in a Single Column | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Threaded Mode
