Truncating a cell's content into a few cells.

[trillicomm]

[cell A1]:
abase adj. To lower in position, estimation, or the like; degrade.
[cell A2]:
abbess n. The lady superior of a nunnery.
[cell A3]:
abbey n. The group of buildings which collectively form the dwelling-place of a society of monks or nuns.
[cell A4]:
abbot n. The superior of a community of monks.

Hi, I have 4 vertical cells above to represent a list of SAT words (5000 cells). Each cell is identical in format as in: 'word(space)type(period)definition(period)'. I need to separate into 3 columns. For ex: [cell A1] will be broken apart into A1, B1, and C1 with "abase", "v.", and "To lower in position, estimation, or the like; degrade.", respectively.

PHPBB forum looks very nice Juan!
Thank you.
Tan Le

 

[Aladin Akyurek]

On 2002-02-25 06:52, trillicomm wrote:
[cell A1]:
abase adj. To lower in position, estimation, or the like; degrade.
[cell A2]:
abbess n. The lady superior of a nunnery.
[cell A3]:
abbey n. The group of buildings which collectively form the dwelling-place of a society of monks or nuns.
[cell A4]:
abbot n. The superior of a community of monks.

Hi, I have 4 vertical cells above to represent a list of SAT words (5000 cells). Each cell is identical in format as in: 'word(space)type(period)definition(period)'. I need to separate into 3 columns. For ex: [cell A1] will be broken apart into A1, B1, and C1 with "abase", "v.", and "To lower in position, estimation, or the like; degrade.", respectively.

PHPBB forum looks very nice Juan!
Thank you.
Tan Le

Tan,

In B2 enter:

=LEFT(A2,SEARCH(" ",A2)-1)

In C2 enter:

=TRIM(MID(A2,SEARCH(" ",A2),SEARCH(".",A2)-SEARCH(" ",A2)))

In D2 enter:

=TRIM(SUBSTITUTE(A2,B2&" "&C2&".",""))

where A2 houses the first entry you want to split.

Aladin

 

[trillicomm]

Thank you Aladin.