Splitting Data in a column

[leewisener]

I have a spreadsheet from an insurance company with all the postcodes in the uk along with other columns.

The problem is I have data from two columns in the one column if that makes sense.

example.

I need 2 columns like:

Buildings rate Contents rate

C 4
D 4
D 4
D 4
D 4

What I am getting is 1 column like:

c4
d4
d4
etc.....

How do I split a column so it display some data in another column?

If this all makes sense, please reply.

 

[DaleWatson123321]

Based on your example, the following will work...

With the data in Column A, enter these formulas.

In B1: =LEFT(A1,1)
In C1: =RIGHT(A1,1)

Then copy the formulas down for the number of rows required.

If your actual data is different from your example, you'll need to adjust the formulas to reference the correct portion of the data.

Depending on the actual data, you might also need to use the =MID function - where with this example =MID(A1,xx,yy), "xx" is the starting point within the text you're referencing (A1), and "yy" is the number of characters you want to extract (or isolate).

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[mattalin]

Another method:

1) Select the cells you want to split.
2) Under Data, click on "Text to Columns..."
3) Check "Fixed Width"
4) Create a "break line" between the data shown - a vertical line should appear which signifies a break in data.
5) Click Finish and you will see the data is broken up into 2 different cells.

Matt