LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 293
Default Splitting cels contents into two cells

Hi all

I have this in Cell m49
Birmingham v West Ham, 15:00
The contents are always displayed with the v in the middle after the hast
name a comma
In this case I would like the Birmingham to appear in cell o49 and west ham
to appear in p49 and ignore the 15:00

the two names change in size bur the v and comma always appear as shown above

Thanks for looking

Stew
 
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
Splitting the contents. Naveed Excel Discussion (Misc queries) 1 June 14th 08 12:59 AM
Splitting cell contents GARY Excel Discussion (Misc queries) 3 November 5th 07 11:53 PM
Splitting cell contents GARY Excel Discussion (Misc queries) 1 November 5th 07 06:58 PM
Autofill cels based on two dates in adjacent cels William2 Excel Worksheet Functions 3 February 1st 06 10:57 PM
Splitting up a cells contents Anthony Excel Worksheet Functions 3 September 1st 05 12:18 PM


All times are GMT +1. The time now is 07:23 PM.

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"