how to split a cell

[CCNProjects]

Hello.
I would like to split a cell in excel, but i do not find the tool to do like in word (right click the cell, split cell)

thanks for any hint.

 

[LNBruno]

Not sure exactly what you're looking for, but take a look at the Right, Left and Mid functions....

< M!ke >
Your right to an opinion does not obligate me to take you seriously.
- Winston Churchill

 

[SkipVought]

Hi,

There is no way to SPLIT a cell. You can, however, split the VALUE in a cell, as Mike has suggested above, using STRING functions.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[SkipVought]

Check out thread68-1394204, just recently answered with multiple solutions.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[Gavona]

One can Merge cells in excel. And if merged one can then unmerge them (which is a bit like splitting).
Select the cell(s)
Format, Cells, Alignment and (tick or) untick the Merge Cells box..

I avoid merging cells if I can possibly avoid it as it can cause complications later. Often folk (unnecessarily) merge cells when they could use Format,Cells, Alignment, horizontal, Centre across selection.

Regards

Gavin

 

[mintjulep]

Of Data | Text to columns might do whatever it is you want to do.

I agree with Gavona, never merge cells. No good can come of it.

 

[fumei]

Merging cells.....bad. And I'm not even an Excel guy. Wait a sec...in Word.....merging cells.....bad.

faq219-2884

Gerry
My paintings and sculpture