LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wally
 
Posts: n/a
Default Separate two words in cell

On sheet2 in cell a1 I have a number and name of a team which is: #1
Wonders. On sheet2 in cell a1, I would like a formula to give me the
name of the team only (Wonders), without the number (#1). Thanks for
your help.
WallyB

 
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
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
How Do? Take two words in cell 1 and slpit them to cell 2 & 3 jermsalerms Excel Discussion (Misc queries) 13 January 6th 06 06:55 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Excel formula for seperating two words in the same cell. Mim New Users to Excel 2 March 8th 05 11:33 PM


All times are GMT +1. The time now is 03:31 PM.

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

About Us

"It's about Microsoft Excel"