Make sure you insert at least one column to the right--you don't want to
overwrite any existing data.
A common question is how to split names up (first/last). It ain't simple.
(Jimmy Johnson, Jr. Dr. Ralph Jones, MD make it difficult.)
Chip Pearson has some worksheet formulas and VBA code at:
for these kinds of things
> how does one "un-merge" info in one column into two? i have info in
> the column that needs to be "split" into two columns, rather than
> having to manually delete the info for each cell...is this possible?
> thanks in advance for your help :)
The Microsoft Web page mentions the Excel 5.0 SDK.
Is this the latest (NON-BETA) version?
Does it have its own web page (I couldn't find one...)
What is the product number for the Excel 5.0 SDK?
Where can I order this product?
Mark S. Johnson http://www.calpoly.edu/~mjohnson/