View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mariekek5 mariekek5 is offline
external usenet poster
 
Posts: 62
Default separate letters from cell

Hi, can someone help me with the following:

In 400 cells I have a name + a code with three letters, for example: Mister
Blackwell RRT. I would like 'Mister Blackwell' in one cell, and 'RRT' in
another cell. Is it possible to separate the three letter code from the name?

Thanks a lot in advance.

Marieke