Home |
Search |
Today's Posts |
#1
|
|||
|
|||
splitting cell values
I have a cell value with something like this:
5830 Paradise Bay - wall or Hickory Woods 26 - footing I need to divide these into two columns separated by the dash. So the address will go in one column and the other term (wall, footing, etc) will go into another. Any ideas? Thanks, Diane |
#2
|
|||
|
|||
splitting cell values
Make sure the column to the right is empty, if not select the column to the
right, right click the header and select insert, now select the column with the text you want split, do datatext to columns, select delimited, click next, check other and put in a dash there, click finish -- Regards, Peo Sjoblom (No private emails please) "Diane" wrote in message ... I have a cell value with something like this: 5830 Paradise Bay - wall or Hickory Woods 26 - footing I need to divide these into two columns separated by the dash. So the address will go in one column and the other term (wall, footing, etc) will go into another. Any ideas? Thanks, Diane |
#3
|
|||
|
|||
splitting cell values
Select the cell (or column of cells???)
and do data|text to columns delimited by other (type in the hyphen character) and finish up. Diane wrote: I have a cell value with something like this: 5830 Paradise Bay - wall or Hickory Woods 26 - footing I need to divide these into two columns separated by the dash. So the address will go in one column and the other term (wall, footing, etc) will go into another. Any ideas? Thanks, Diane -- Dave Peterson |
#4
|
|||
|
|||
splitting cell values
Thanks Peo and Dave. That's exactly what I needed. I couldn't remember where
it was! Diane "Dave Peterson" wrote in message ... Select the cell (or column of cells???) and do data|text to columns delimited by other (type in the hyphen character) and finish up. Diane wrote: I have a cell value with something like this: 5830 Paradise Bay - wall or Hickory Woods 26 - footing I need to divide these into two columns separated by the dash. So the address will go in one column and the other term (wall, footing, etc) will go into another. Any ideas? Thanks, Diane -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
column values to a cell with comma seperated | Excel Worksheet Functions | |||
VLookup to sum cell values | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Splitting a cell | Excel Worksheet Functions |