+ Reply to Thread
Results 1 to 2 of 2

Insert text rows into excel sheet cells

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Insert text rows into excel sheet cells

    Hi, I need to get the following info into an excel sheet.
    1 - Remove the numbers at the beginning
    2 - Put the four answers in their own cell + remove the A, B, C, D so smth like this
    hold keep save stay

    1 A hold B keep C save D stay
    2 A searching B looking C seeking D gaining
    3 A engage B combine C contribute D involve
    4 A motive B purpose C intention D cause
    5 A excluding B except C apart D away
    6 A assets B profits C services D benefits
    7 A plan B prepare C practise D provide
    8 A brief B short C narrow D little

    Thanks for any help.

  2. #2
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Re: Insert text rows into excel sheet cells

    Found it.
    I import into dreamweaver - substitute the A, B etc... with a colon ( then import into excel with that delimeter.
    Sorry if I wasted somebody's time.
    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert Rows in between cells of text in different column
    By king10001 in forum Excel General
    Replies: 2
    Last Post: 05-26-2015, 11:46 AM
  2. [SOLVED] insert rows based on text values in cells
    By simarui in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2014, 07:54 PM
  3. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  4. Replies: 1
    Last Post: 10-22-2012, 03:26 AM
  5. [SOLVED] Code to cut and paste rows (insert cut cells) in a protected Excel sheet
    By bob.mc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 04:47 PM
  6. Insert rows beneath cells containing specific text
    By adame in forum Excel General
    Replies: 2
    Last Post: 07-22-2011, 07:07 AM
  7. insert text in a no. of cells of each sheet?
    By hally in forum Excel General
    Replies: 3
    Last Post: 05-06-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1