Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Truncating a cell's content into a few cells.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [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

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,658
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you Aladin.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •