How do i get everything right of a character in cells

[emerald_joc]

The character in this case is the 1st. space

Example
I have... (2 columns)
9. What kind of food is Penne? 9. Pasta
10. How many days are there in February during a leap year? 10. 29

I want...
What kind of food is Penne? Pasta
How many days are there in February during a leap year? 29

I have got part way there (single column) using this (but have not worked out how to get multiple columns at the same time)
=RIGHT(C1,LEN(C1)-FIND(" ",C1))

[mehmetcik]

=right(c1,len(c1)-find(" ",c1)) & " " & right(d1,len(d1)-find(" ",d1))

[emerald_joc]

Thanks.

I should have added...
I want to retain the 2 columns (questions and answers) after executing the Formula

questions column C
answers column D

[emerald_joc]

Anyone ? ❓

[AliGW]

Do you mean that you want the formula to act on the existing columns? If so, you can't do that. A cell can contain either a value or a formula, but not both. What you can do is extract what you need to two new columns, then maybe hide columns C and D. If that's not acceptable, then it's VBA, I'm afraid.

In column E:

=TRIM(MID(C1,FIND(" ",C1)+1,999))

In column F:


=TRIM(MID(D1,FIND(" ",D1)+1,999))

[janmorris]

the formula by mehmetcik simply looks for the space, and returns everything after it, while the & symbol joins them together, so just split them into 2 columns

in E1:

Please Login or Register  to view this content.

in F1:

Please Login or Register  to view this content.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[emerald_joc]

Thanks for the help.
Solved