Hi Lovell,
The method to use depends on how the three items are separated. If there
is a unique character between them you could download and install the
'text2columns' macro. If there are only spaces, you could use the 'find'
and 'mid' functions to parse the cell. Something like:
=mid(C1:1:find(" ",C1)-1)
Would give you the city if the data is in cell C1. Finding the next two
is a little more complicated, but possible.
tc
Lovell Mcilwain wrote:
Hello all,
Can anyone tell me how I can split the contents of one cell into
separate cells?
Right now I have spreadsheet that is formatted with city, state and
zip all in the same cell and I need to split it so that cit, state,
and zip have there own cell.
I wasn't able to find this in the help so Im kinda at a loss.
Thanks,
Lovell
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
