Text formula that inserts a text string in front of multiple choice questions

[CatsIgnoreMe]

I need to add two line break symbols (

) before each multiple choice. Values will range from a. to g.

Some questions might have a. , b. and c. while others might have all the way to g.
Below are before and after examples. Thank you for your assistance on this.

Current Value Example:
[TABLE="width: 899"]
<tbody>[TR]
[TD="class: xl63, width: 899"]How would you configure a profile to find duplicate records? a. read,edit b. view all c. merge d. delete

Same Value After Excel Formula is Applied:
How would you configure a profile to find duplicate records?

a. read,edit

b. view all

c. merge

d. delete
[/TD]
[/TR]
</tbody>[/TABLE]

 

[CatsIgnoreMe]

Whoops! The question got mangled because I used HTML! Here's a screenshot of BEFORE the text formula and AFTER the text formula.

 

[JoeMo]

Not sure I understand - see if this macro does what you want. First select all the cells you want to alter using your mouse, then run the macro. Test on a copy of your data.

Sub AddBreaks()
'select cells first, then run this macro
Dim c As Range, Where As Variant, i As Long, n As Long, S As String
Where = Array("a.", "b.", "c.", "d.", "e.", "f.", "g.")
Application.DisplayAlerts = False
For Each c In Selection
    S = c.Value
    For i = LBound(Where) To UBound(Where)
        n = InStr(S, Where(i))
        If n > 0 Then
            Mid(S, n - 1, 1) = Chr(10)
        End If
    Next i
    c.Value = S
    c.WrapText = True
    c.EntireRow.AutoFit
Next c
Application.DisplayAlerts = True
End Sub

 

[CatsIgnoreMe]

I will test tomorrow and give you an update. Initial super quick test looks good, but I also need to test more thoroughly.
VBA macros are over my head. Many thanks for the great response.

 

[CatsIgnoreMe]

JoeMo - The macro you kindly created works well in Excel, however, the reason behind my asking for the

<br><br>

is because I save the Excel file into CSV format, and then import the CSV file into Anki . The HTML

<br><br>

code is needed for Anki to create the line breaks.

CatsIgnoreMe

 

[CatsIgnoreMe]

Apologies for the messed up message above.

 

[JoeMo]

JoeMo - The macro you kindly created works well in Excel, however, the reason behind my asking for the

is because I save the Excel file into CSV format, and then import the CSV file into Anki . The HTML

code is needed for Anki to create the line breaks.

CatsIgnoreMe

Sorry, Anki is unknown to me.