View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Filo Filo is offline
external usenet poster
 
Posts: 54
Default 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!!