View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Timbo Timbo is offline
external usenet poster
 
Posts: 19
Default Formula for duplicating info from one cell to another

I'd like information that I input into a cell to be automatically output into
another cell. So, for example, In one cell I input the following information:

HWC65917 P Science / Health & Medical Sciences / Human Anatomy & Physiology
/ Human Systems / Immune/Lymphatic System / Diseases & Disorders / Other
Lymphatic Disorders

In the cell next to it I'd like it to automatically output

Science / Health & Medical Sciences / Human Anatomy & Physiology / Human
Systems / Immune/Lymphatic System / Diseases & Disorders / Other Lymphatic
Disorders

by excluding the HWC65917 P.


Is this possible?

Thanks.