Thread: Another Text to Columns question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net Martin ©¿©¬ @nohere.net is offline
external usenet poster
  
Posts: 80
Default Another Text to Columns question
Hi
I have the name McAllister Mr & Mrs E.
When I use text to columns it becomes Mr & Mrs E.McAllister
However, I want it to be Mr & Mrs E. McAllister
(with a space between E. & McAllister)

How would I do that please?
--
Martin
©¿©¬
Reply With QuoteReply With Quote