Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default break the cell by words

Dear,

Please send me the formula to break/trim the words from one cell of Excel.

Example:
A B C
1 Main Road Main Road
(given) (Required) (Required)


Regards,

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default break the cell by words

u can very well use 'text to columns' option...

try these sites
http://office.microsoft.com/en-us/ex...498511033.aspx
http://forums.aspfree.com/visual-bas...ame-37434.html



"Shaffiqe" wrote:

Dear,

Please send me the formula to break/trim the words from one cell of Excel.

Example:
A B C
1 Main Road Main Road
(given) (Required) (Required)


Regards,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy the first word or two words from a cell containing a complete sentence to another cell jonny Excel Discussion (Misc queries) 7 May 19th 23 03:43 AM
How to line break in one cell via a formula to stack cell entries Barb @ Work Excel Worksheet Functions 7 April 15th 08 09:01 PM
Break Apart a Cell, please help a newby Newby Excel Discussion (Misc queries) 2 May 2nd 07 12:21 AM
Excel pie chart title words break to next line between letters? sweetsweed Charts and Charting in Excel 0 October 9th 06 07:10 PM
Break cell into multiple lines by line break Chia Excel Discussion (Misc queries) 1 August 20th 06 06:37 AM


All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"