If there are no periods that you need...
Highlight the cell/column, Ctrl-H, Find "." and replace with (leave this
blank).
Now you can use Text to Columns Feature
--
Mike Q.


"Filo" wrote:

Cell A1 includes the following text:

16365 HR ADMIN
25005 UNGRADED-Intern - HS

There is a period between the two strings, but it is all in one cell.

How can I eliminate the period and display the text as such?

16365 HR ADMIN 25005 UNGRADED-Intern - HS

I am trying to use the Text to Columns feature and if the data includes the
period, it doesn't work.

Thank you!!