Webhosting in Pakistan
Results 1 to 7 of 7

Thread: Excel Text Formula Help

  1. #1
    Ahmad Ghaffar's Avatar
    Ahmad Ghaffar is offline Senior Member+
    Last Online
    18th April 2019 @ 04:21 PM
    Join Date
    19 Jun 2009
    Location
    K.R.K
    Age
    31
    Gender
    Male
    Posts
    365
    Threads
    112
    Credits
    708
    Thanked
    6

    Post Excel Text Formula Help

    Webhosting in Pakistan


    agr Excel kay Cell A main ak text hai.

    Health Information

    I want to required text in cell B i.e (Formula) alphabet a sy start ho aur h tk text aa jay in cell B main. kaisay karain gay.

  2. #2
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    Yesterday @ 12:01 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,674
    Threads
    66
    Credits
    9,156
    Thanked
    78

    Default

    Quote Ahmad Ghaffar said: View Post


    agr Excel kay Cell A main ak text hai.

    Health Information

    I want to required text in cell B i.e (Formula) alphabet a sy start ho aur h tk text aa jay in cell B main. kaisay karain gay.
    Kis maqsad ke lye chahiye or please thora aur detail bataynge jo requirement hai
    Desert Rose
    A Simple Person With Complicated Mind

  3. #3
    smhrschool is offline Senior Member+
    Last Online
    20th September 2019 @ 12:00 AM
    Join Date
    10 Sep 2018
    Gender
    Male
    Posts
    50
    Threads
    5
    Credits
    330
    Thanked
    4

    Default

    Desert Rose Sahib maine bhi apna question taqreeban 3 se 4 dino se dya hai but koe response nahi hai pls meri problem bhi solve krden.

  4. #4
    smhrschool is offline Senior Member+
    Last Online
    20th September 2019 @ 12:00 AM
    Join Date
    10 Sep 2018
    Gender
    Male
    Posts
    50
    Threads
    5
    Credits
    330
    Thanked
    4

    Default

    Thanks 4 reply Desert Rose Sahib mai file attach kr raha hon or is file ki tamam sheet mai maine "Dues" wale column mai work kya hai but mai ye chahta hon k isi file k ander ek new sheet banai jai or j se he mai dues k column mai d press krne k bad enter kron wo wahi row ki tamam data copy ho kr dues wali sheet mai paste ho jai. mere khayal hai ap sumjh gae honge pls mujhe batain.
    Note: is trah ki mazeed files or bhi hain total sheets 30 hongi janab. maine file attach krne ki koshish ki thi but i think k *.xlx file ki uploading requirement 488 kb hai shayed isi waja se upload nahi hosaki apko screen shots de raha hai kindly help me pls.

    Thanks
    Attached Images Attached Images    

  5. #5
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    Yesterday @ 12:01 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,674
    Threads
    66
    Credits
    9,156
    Thanked
    78

    Default

    Quote smhrschool said: View Post
    Thanks 4 reply Desert Rose Sahib mai file attach kr raha hon or is file ki tamam sheet mai maine "Dues" wale column mai work kya hai but mai ye chahta hon k isi file k ander ek new sheet banai jai or j se he mai dues k column mai d press krne k bad enter kron wo wahi row ki tamam data copy ho kr dues wali sheet mai paste ho jai. mere khayal hai ap sumjh gae honge pls mujhe batain.
    Note: is trah ki mazeed files or bhi hain total sheets 30 hongi janab. maine file attach krne ki koshish ki thi but i think k *.xlx file ki uploading requirement 488 kb hai shayed isi waja se upload nahi hosaki apko screen shots de raha hai kindly help me pls.

    Thanks
    Bhai jo ap keh rahe hai is key lye behtar hai aap tamam data pe FILTER apply karde.... Isi tarah filter mai aap D select karainge to DUES wala data he show hoga

  6. #6
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    Yesterday @ 12:01 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,674
    Threads
    66
    Credits
    9,156
    Thanked
    78

    Default

    Maine example ke lye aik sample file attach ke hai.. pls check and reply

    PS. Yellow line ke uper ka data filter hai, islye ager ap kuch mazeed data enter karna chahte hai to yellow lineke uper NEW ROWS insert karai
    Attached Files Attached Files

  7. #7
    smhrschool is offline Senior Member+
    Last Online
    20th September 2019 @ 12:00 AM
    Join Date
    10 Sep 2018
    Gender
    Male
    Posts
    50
    Threads
    5
    Credits
    330
    Thanked
    4

    Default

    Webhosting in Pakistan
    Quote KingKhan84 said: View Post
    Maine example ke lye aik sample file attach ke hai.. pls check and reply

    PS. Yellow line ke uper ka data filter hai, islye ager ap kuch mazeed data enter karna chahte hai to yellow lineke uper NEW ROWS insert karai
    Kingkhan sahib apka reply krne ka or sample file dene ka bohat shukriya.. mujhe filter k bare mia pata tha but sorry maine is bare mai pehle nahi bataya, filter se bhi meri problem solve nahi ho rahi kyoun k agar kisi sheet mai ek ya do students ki fee dues hain to mai os page ka print nahi nikal sakta kyoun k page zaya ho jaiga is lea mai aisa krna chah raha hon k tamam dues wale students dues ki sheet mai transfer ho jai like copy and paste. i think meri bat ap sumjh gae honge sir..
    Thanks

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 11:06 AM
  2. excel pr formula
    By meerabkhan in forum Ask an Expert
    Replies: 5
    Last Post: 30th March 2014, 04:30 PM
  3. Solved Excel formula
    By masadijaz in forum Solved Problems (IT)
    Replies: 8
    Last Post: 15th July 2011, 11:39 AM
  4. excel formula need
    By alim khan in forum Ask an Expert
    Replies: 6
    Last Post: 11th April 2010, 11:31 AM
  5. help about excel formula....?
    By ihtesham_ulfat in forum Ask an Expert
    Replies: 1
    Last Post: 24th March 2009, 11:24 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
  •