| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : How to segregate text into columns ? | Excel Discussion (Misc queries) | |||
| Text to columns, split at first space only | New Users to Excel | |||
| macro to split text in columns | Excel Discussion (Misc queries) | |||
| split text , insert to columns | Excel Discussion (Misc queries) | |||
| How do I split 16 char text 'XX XXX= +. X' into 16 columns | Excel Discussion (Misc queries) | |||
Threaded Mode
