+ Reply to Thread
Results 1 to 2 of 2

vba or formula to pull text out of cell

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    vba or formula to pull text out of cell

    Hello. I'm copying from a pdf table into the first column in excel. The text to column doesn't work very well (it splits up the text, which is the first part). The first part ends up being text and the rest is numbers. Can I pull just the text (or the characters) out?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: vba or formula to pull text out of cell

    maybe, but can we see some sample data?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Excel does not pull value from the cell - appears to pull formula
    By enjoyexcel in forum Excel General
    Replies: 2
    Last Post: 01-06-2015, 11:42 AM
  2. [SOLVED] Pull Text Not Formula
    By Jarrettm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-12-2014, 09:11 PM
  3. [SOLVED] Pull text from one cell into formula in a differenet cell
    By tazman1911 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 03:08 PM
  4. Code/Solution To Search All Text in a Cell and Pull UniqueID Corresponding to the Text
    By brandnew22 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-06-2013, 10:56 AM
  5. Formula to pull text from multiple cells if formula = true
    By bommar2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2013, 12:16 PM
  6. Replies: 0
    Last Post: 06-22-2006, 03:20 PM
  7. Replies: 1
    Last Post: 04-12-2006, 05:00 PM

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