Excel Parsing Column - Help

[121854]

Need to parse a column in excel that contain the following information. Could someone provide me some guidance so that I can parse this column using Excel or a macro or in VBA.

The information that I need to parse is:
Column A:
"25209
375487
BroadBand (WEST)"

Need to parse it like:
Column D Column E Column F
25209 375487 BroadBand (West)

Your assistance will be appreciated.

 

[PHV]

Take a look at the Split function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jackha18]

if you parse it only to put column information accross several rows you can copy the the column range and then paste it back using transpose option which actually "rotates" columns to rows and back:

With Worksheets("Sheet1")
.Range("A1:A3").Copy
.Range("D1:F1").PasteSpecial xlPasteAll, xlPasteSpecialOperationNone, True, True
End With

(transpose is the last true statement)