I have a Master Excel sheet consisting of roughly 2678 observations all in one column. Each observation consists of information such as address, owner, number of beds, name of business etc.. The problem is that all of that info is contained within the same cell. I would like to take the information for each observation and space it out across multiple columns for each observation. The catch is that the data is not consistent across all observations and so the Text to Column function in Excel is not up to the job.