Questions

Answer for:

I want to ask about a formula. Is any way to do?

Message 2 of 14

View entire thread
+
1 Votes
Scalloway1

If "c" is always the first character in the cell you could use this. It assumes that your first item of data is in A1

=IF(LEFT(+A1,1)="c",

Then type in what you want to do after the ","