Thread: how can I make info in one cell appear in 3 different columns?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
  
Posts: 747
Default how can I make info in one cell appear in 3 different columns?
Select the column & then

Go to Data | text to columns | Click Fixed Width | next | finish



On Apr 20, 8:26*am, Joe wrote:
I'd like to take something like this out of one cell:

White Plains, New York 10604

and make it appear in 3 different columns, is it possible?

Reply With QuoteReply With Quote