Results 1 to 4 of 4

How to separte the letters in an excel sheet by using formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    28

    How to separte the letters in an excel sheet by using formula

    Dear Friends,


    I would like to separate the first letter and rest of sentence in two different columns in an excel sheet by using the formula. I could separate the first letter by using the function =left(A1,1), in another column which is B. But not able to apply the same logic for rest of sentence, as the same is containing number of letters. Hence kindly guide me here which formula needs to be applied for the same to exlude the first letter in column C.


    Attached an excel sheet for your ready reference.


    Thanks in advance,
    Attached Files Attached Files
    Last edited by Venkata Krishna; 12-23-2013 at 08:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] creating a list based on two separte values
    By scokaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2013, 02:28 PM
  2. Replies: 8
    Last Post: 06-07-2012, 09:14 AM
  3. Replace all symbols/letters according to a list in 2nd. sheet
    By wali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2009, 04:07 AM
  4. [SOLVED] Separte columns for neg/pos values
    By Ginger in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-01-2006, 05:15 PM
  5. Replies: 4
    Last Post: 11-02-2005, 06:17 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