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: 62
Default separate columns (three letter code)

Hi, does someone know how to separate text from one column into two columns?

I have columns like
[dog, KKL]
[horse, PPN]

Everytime, three capitals in the end (which is a code).

Is it possible to separate that, and put it in another column?

Thanks in advance.
 
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 change address, city, state zip code into separate columns mastertype Excel Discussion (Misc queries) 2 September 15th 09 06:41 PM
Converting RIC1 code to letter Column/Numeric Row RidgeView Excel Discussion (Misc queries) 5 March 8th 09 12:09 AM
Looking for code to separate one line of text into multiple lines in Excel [email protected] Excel Worksheet Functions 1 February 13th 07 12:59 AM
doing mail merge with excel the first letter in zip code is missi Andrew A. McBain DC Excel Discussion (Misc queries) 1 August 29th 06 01:26 PM
I wish to separate city, state, and zip into 3 separate columns Bob Woolbert Excel Worksheet Functions 1 July 11th 06 05:29 PM


All times are GMT +1. The time now is 06:53 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"