Results 1 to 5 of 5

add prefix to number based on other data

Threaded View

oeyandyprawira add prefix to number based on... 12-04-2018, 10:34 AM
mikerickson Re: add prefix to number... 12-04-2018, 10:42 AM
Richard Buttrey Re: add prefix to number... 12-04-2018, 10:44 AM
oeyandyprawira Re: add prefix to number... 12-04-2018, 10:50 AM
Richard Buttrey Re: add prefix to number... 12-05-2018, 04:19 PM
  1. #1
    Forum Contributor
    Join Date
    12-17-2012
    Location
    indonesia
    MS-Off Ver
    Excel 2019
    Posts
    170

    add prefix to number based on other data

    Hi All is that macros to do this,

    in column K there is phone number , but I need to add prefix based on the city location on column T
    before.JPG

    on column BL and BM there is information which prefix should be used referring the city location if possible not using precise word but using any if not possible then using precise word, as example in prefix information Bandung is 022, but T is Bandung (Binong) , as Bandung found in information prefix then will use this prefix
    Information prefix.JPG

    so it's gonna be like this after prefix added. thx
    after.JPG
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Multi-line Data Based on prefix and format
    By chilli16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2018, 11:15 AM
  2. [SOLVED] Extract Multi-line Data Based on prefix
    By chilli16 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-29-2018, 05:15 AM
  3. Replies: 4
    Last Post: 08-07-2017, 06:45 PM
  4. VBA Automatically concatenate cell data based on data, and prefix with specific word.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2017, 02:16 PM
  5. extracting page number ranges based on prefix of sorted data
    By wdjohnson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2016, 05:34 PM
  6. Replies: 2
    Last Post: 08-11-2015, 05:22 AM
  7. Adding 0 as prefix for number when number is quoted
    By VIJEXCEL in forum Excel General
    Replies: 3
    Last Post: 04-05-2011, 05:38 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