Cell Format Problem
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!!
|