Thread: remove or adding spacing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default remove or adding spacing
Post some samples of the data that you have (is it all in one cell?, etc),
and explain exactly what you seek to achieve (describe the expected results)

Some general thoughts:
To remove extraneous spacings - Try TRIM
To split data in one col into separate cols - Try Data Text to Columns
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---


Reply With QuoteReply With Quote