Split a column with no delimiter

[Bassplaya7]

I have a spreadsheet that has 2417 cells of web page id's in column A.
(example:<table border="0" cellpadding="0" cellspacing="0" width="328"><tr height="17"><td class="xl24" style="height:12.9pt;width:246pt" height="17" width="328">crayons-pack-1004)</td> </tr></table>
I would like to split the large column into 3 separate, equal columns B, C, D.
Is there a function that will help me do this?

 

[anandvarma]

try

text to column

 

[Trevor G]

If your columns have a dash (-) inbetween words you can use that as a Delimiter, Place all the data in a single column then select the column then select Text to Columns in the guide select Delimited and then Next in the Next part of the guide select other and place in the -.

A sample converted is shown below.

Excel Workbook
	D	E	F	G	H
1	crayons-pack-1004		crayons	pack	1004
2	crayons-pack-1005		crayons	pack	1005
3	crayons-pack-1006		crayons	pack	1006
4	crayons-pack-1007		crayons	pack	1007
5	crayons-pack-1008		crayons	pack	1008
6	crayons-pack-1009		crayons	pack	1009
7	crayons-pack-1010		crayons	pack	1010
8	crayons-pack-1011		crayons	pack	1011
9	crayons-pack-1012		crayons	pack	1012
10	crayons-pack-1013		crayons	pack	1013
11	crayons-pack-1014		crayons	pack	1014
12	crayons-pack-1015		crayons	pack	1015
13	crayons-pack-1016		crayons	pack	1016
14	crayons-pack-1017		crayons	pack	1017
15	crayons-pack-1018		crayons	pack	1018
16	crayons-pack-1019		crayons	pack	1019
Sheet1

 

[Bassplaya7]

text to column won't work. I don't need to split the information in the cells. i need to split the column. I need the column side by side of all the information in column A.

 

[taurean]

Just curious, why do you need such formula? Here is one:

=IF(ROW()<=CEILING(COUNTA($A:$A)/[COLOR=red]3[/COLOR],1),INDIRECT("A"&(CEILING(COUNTA($A:$A)/[COLOR=red]3[/COLOR],1)*(COLUMN()-2)+ROW())),"")

This formula is for 3 columns but you can expand it to as many columns you want by changing the red lettered part. e.g. for 4 columns replace 3 with 4 etc.

 

[Bassplaya7]

now that they are in 3 rows, i can concatenate into one cell with 3 page id's with a space between. I need the info for internet retail using yahoo small business. when i put the page id's into a mss-cross-reference it shows the customer must have items on the right hand side of a product page. Thanks