+ Reply to Thread
Results 1 to 2 of 2

Replacement Function

  1. #1
    Registered User
    Join Date
    01-17-2008
    Posts
    1

    Thumbs up Replacement Function

    When I make work sheet and I make name column , phone. Mobile ......etc

    When I write in Names column pater . Toni...etc.

    Instead to write Peter every time I write only the number 2 for example
    press this link to see example
    \1

    When I make replacement for number 2 to write peter the

    I make replacement from :-menu edit – search – replace

    whole sheet carry number 2 will change to peter

    My Question:- how can I change only the number 2 in name column only without
    Change the whole sheet.

    Which function can I used , can I programmed it?

    second Point::
    In the excel cell this have 7 number :

    For example

    5741896
    5287682
    5852413
    5147849
    5174589

    i want to replacement the number 5 in left side with 550/ only the 5 in beginning left side in same cell .

    the problem is any 5 in the same cell is replacement by 550/
    which function can i use it ? can i programmed it?
    Last edited by VBA Noob; 01-17-2008 at 05:51 PM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    for second bit
    If all begin with 5 try this
    insert a column after the number
    and in cell next to number enter this
    ="550/"&MID(A1,2,6)
    drag down to end of column
    that will give you 550/xxxxxx
    then once done select that column
    copy
    then paste special 'values' back
    this will remove formulas and just leave the value
    you can then coy thes into the corect column and then delete the additional column

    [if you have different leading numbers you dont want them changed
    try ]
    =IF(LEFT(A1,1)="5",("550/"&MID(A1,2,6)),A1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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