corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Excel


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel
topshot_2k
Banned
Registered: 1st Dec 03
Location: Northampton Drives: Pug GTi-6
User status: Offline
11th Dec 06 at 09:55   View User's Profile U2U Member Reply With Quote
what function do you use to splite a string of text into 2 strings?

E.g i want to split: Smith, John

Into 2 columns:

Surname Name
Smith John
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
11th Dec 06 at 11:13   View Garage View User's Profile U2U Member Reply With Quote
Text to Columns on the Data menu.
topshot_2k
Banned
Registered: 1st Dec 03
Location: Northampton Drives: Pug GTi-6
User status: Offline
11th Dec 06 at 13:39   View User's Profile U2U Member Reply With Quote
yea i was trying to use the function menu. Cheers

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1656
21st Mar 03 at 00:15
by Red_Corsa		  
Any MS Excel experts Steve Geek Day 11 1273
4th Jun 04 at 14:19
by blebo		  
is there a program that...... chris_uk Geek Day 6 1879
16th Jun 05 at 00:47
by Dan B		  
Excel Help please !!! Mase Geek Day 2 744
16th Nov 05 at 11:27
by Mase		  
Excel help and making my life easier Melville Geek Day 9 955
26th Oct 06 at 14:17
by Melville		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel 29 database queries in 0.0129290 seconds