Adding Numeric values to the Left of the Text? I want to add numbers to the left

ID: 3560693 • Letter: A

Question

Adding Numeric values to the Left of the Text?

I want to add numbers to the left of the string of the texts, separated by a hyphen. For example :

The cost strategies are ineffective since 12-May-08.

The pricing includes hotel, flight, and ground level transportation charges.

I want the sentences to be preceded by numeric values :

1- The cost strategies are ineffective since 12-May-08.

2- The pricing includes hotel, flight, and ground level transportation charges.

and so on...

In addition, is it also possible to add alphabetical character to the left of the text, for example : A- , B- , and so on...

Please assist with a formula..

&^%$Need an example of - "however can this be limited to 3 numbers only in sequence, or whatever number, I want to assign."

If you want to limit to say 1,2,3 and repeat 1,2,3 again and again

=IF(MOD(ROWS($1:1),3),MOD(ROWS($1:1),3),3)&"- "&A1

IF you want to limit to 5, 6, 7 only -

=IF(MOD(ROWS($1:1),3),MOD(ROWS($1:1),3),3)+4&"- "&A1

For other numbers, manipulate 4 in bold accordingly.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.