ExcelBanter - Text to Columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text to Columns (https://www.excelbanter.com/excel-discussion-misc-queries/100101-text-columns.html)

Hi

The result in the cell I want to split is a date / time format - generated
by a formula. Previously I have had no problems with this but all of a
sudden I can no longer see the result in the data view pane on the wizard
merely the formula therefore I cannot split. Please help!!

Thanks

Copy the cell, then Paste Special-Values. Then try the text to columns again.

--
Regards,
Dave

"bee1000" wrote:

Hi

The result in the cell I want to split is a date / time format - generated
by a formula. Previously I have had no problems with this but all of a
sudden I can no longer see the result in the data view pane on the wizard
merely the formula therefore I cannot split. Please help!!

Thanks

Thanks Dave - this does work as this is the work around I have used. What I
don't understand is why I suddenly need to do this?! (Halfway through a
spreadsheet on a differrent tab!!)

Briony

"David Billigmeier" wrote:

Copy the cell, then Paste Special-Values. Then try the text to columns again.

--
Regards,
Dave

"bee1000" wrote:

Hi

The result in the cell I want to split is a date / time format - generated
by a formula. Previously I have had no problems with this but all of a
sudden I can no longer see the result in the data view pane on the wizard
merely the formula therefore I cannot split. Please help!!

Thanks