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

[Venkata Krishna]

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,

[etaf]

you could use
mid()

=mid(A1,2,len(a1)-1)

looks like there is a space at the start of each new sentence , so to avoid that use

=TRIM(MID(A2,2,LEN(A2)-1))

[Venkata Krishna]

Thanks a lot for valued help

[etaf]

your welcome

If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.