Software

Ask something
Question Locked

Excel -- breaking data in one cell to multiple

0 helpful
4 replies

by pakoppan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is a question already made by someone but I was not able o find the "questions Forum" as such. I guess this is the Question Forum, the right place to go.

Given 1 colunn say, column C I hace the following data

city, state(abbreviated) zip(5 digits)
city state zip
city111 state zip
and so forth ad nauseam...
I need to break these into 3 different columns

column D would hold the City
column E would hold the State
Column F would hold the zip code

for each row in column C.

Is there a way to do that?
If so, could someone give me a help?

Thanks

pakoppan

4 replies

by absolutely

Start by putting the function 'FIND' in column D next to your first line. Have it look for spaces, ' '. The return value is a number showing the position from the left where that character first appears. You'll have to use that return value in another 'FIND' function in column D, which tells you where the State ends/zip begins. Then use 'LEFT' & 'MID' functions, using those return values, in separate functions.

by pakoppan

Hi,

Thanks for the help.
Will implement it and case closed.

pakopan

This discussion is closed to new replies.