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

kumar

New member
Joined
Dec 17, 2013
Messages
11
Reaction score
0
Points
0
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 exclude the first letter in column C.


Attached an excel sheet for your ready reference.


Thanks in advance,
 

Attachments

  • Book3.xlsx
    9.3 KB · Views: 24

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,779
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Alternatively - Data - Text to columns - fixed width - insert a line break after the first character - Done
 
Top