| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Splitting Cell Data
I have about 900 cells and all of them appear in the following way
A Town, State, 99999 Town1, State1, 11111 I need to have the zip code (99999 in the example) in one column, and then town and state in another column so it would look like this A B Town, State 99999 Town 1, State 1 11111 I've been experimenting with the RIGHT and LEFT formula-- =RIGHT (A1, 5) which would give me the zip code. The problem is i can only do this for individual cells so i would have to do A1, A2, A3 and so on. Is there a way to write a macro or formula to get all of the cells to transfer over without having to type A1 over and over? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
| how do i reference data in a file with the fname in another cell? | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Import Data into same cell | Excel Discussion (Misc queries) | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
Threaded Mode
