Results 1 to 5 of 5

adjust existing splitting formula from number and text

Threaded View

JEAN1972 adjust existing splitting... 08-19-2018, 06:44 AM
Bosco Re: adjust existing ... 08-19-2018, 07:01 AM
Glenn Kennedy Re: adjust existing ... 08-19-2018, 08:02 AM
JEAN1972 Re: adjust existing ... 08-19-2018, 10:30 AM
Glenn Kennedy Re: adjust existing ... 08-19-2018, 11:16 AM
  1. 08-19-2018, 06:44 AM #1
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,145

    adjust existing splitting formula from number and text

    I have column A with quantity 20 .EA,20PKS the data is split in column B and C as column B and column C EA OR pks .

    I have a new qty as 1020 UVC OR 5 UVC OR 100 UVC

    Can someone help how to adjust formula to accept the split the nunber and uvc for both column B and C


    COLUMN B FORMULA
    =--SUBSTITUTE(LEFT(A2,FIND(".",A2)-1)," ","")
    COLUMN C FORMULA

    
=TRIM(MID(A2,-LOOKUP(1,-MIN(SEARCH({"EA","PKS"},A2&"EAPKS"))),3))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] assistance to adjust splitting formula in certain column headers which blank cells
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2018, 05:03 AM
  2. [SOLVED] Formula to adjust row number when copying cell
    By Solvax in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2018, 03:27 PM
  3. [SOLVED] Splitting cell text strings at 4-digit number and at space after # symbol
    By portokie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2013, 09:57 PM
  4. Problems splitting a text & number string using VBA
    By Tamor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2009, 11:03 AM
  5. Need formula for -- If Text = 1 and Text =-1 adjust running total
    By Boharris in forum Excel General
    Replies: 3
    Last Post: 05-14-2009, 10:31 AM
  6. adjust my existing macro
    By jpfulton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2008, 06:00 PM
  7. Need to adjust existing named range for dynamic charts
    By tbonejo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2006, 12:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1