View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default Excel 2002: How to split text into columns ?

Dear Sir,

I have the folowing text entry at column A and would like to split it into
column B,C,D and E by eliminating the . between them.

A B C
D E
1 110201.02.HGF.0702 110201 02 HGF
0702
2 110202.03.LKJ.0254 110202 03 LKJ
0254
3 110541.06.PKL.0365 100541 06 PKL
0365

Do you have any formula that I can inout at B1 and copy down to get the
straight answer ?

Thanks

Low



--
A36B58K641