Results 1 to 4 of 4

Thread: Need help in excel

  1. #1
    adnanbahrian is offline Advance Member
    Last Online
    29th May 2023 @ 08:21 PM
    Join Date
    08 Aug 2007
    Location
    Karachi
    Age
    41
    Gender
    Male
    Posts
    1,238
    Threads
    421
    Credits
    317
    Thanked
    63

    Default Need help in excel

    yai aik excell sheet ki snapshot attached ki hue hay , is ma manay kahin say data copy kar kay excel 2007 ma paste kia huwa hay.

    But each cell ma extra space arahe hay jis ki wajah say total sum nai araha.

    Ma chahta kay within few seconds saray spaces remove ho jayn.

    Thanks
    Attached Images Attached Images  

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote adnanbahrian said: View Post
    yai aik excell sheet ki snapshot attached ki hue hay , is ma manay kahin say data copy kar kay excel 2007 ma paste kia huwa hay.

    But each cell ma extra space arahe hay jis ki wajah say total sum nai araha.

    Ma chahta kay within few seconds saray spaces remove ho jayn.

    Thanks

    In adjacent column try this

    =
    Code:
    SUBSTITUTE(I1," ","")+0
    and copy down as far as required.agar aap ka matlooba result mil jae tu thk ha wrna apna 10,15 line ka sample data attached kr dain.

    Agar masla hal ho jae tu new column ko select kr k copy karain aur phr paste special m ja kar paste as values ko select krain aur apne Column I ko delete kr dain. agar aap ko masla ho tu file attached kr dejeye ga.

    regards,

  3. #3
    adnanbahrian is offline Advance Member
    Last Online
    29th May 2023 @ 08:21 PM
    Join Date
    08 Aug 2007
    Location
    Karachi
    Age
    41
    Gender
    Male
    Posts
    1,238
    Threads
    421
    Credits
    317
    Thanked
    63

    Default

    nops , masla hal nai huwa mara

  4. #4
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Please attached sample sheet of 10-15 lines.

    regards

Similar Threads

  1. Answered MS Word Ki file ko JPG me kesy convert kru?
    By 1heart2pain in forum Ask an Expert
    Replies: 10
    Last Post: 24th May 2010, 02:34 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

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
  •