In the Google Sheets app on Android and iOS, you can select a cell or cells, then tap the Text/Cell format icon in the upper right; it displays as an A with a few horizontal lines to the right.

Text is my source cell location. If my first row of text is in cell A2, text value will be cell A2. Clicking and dragging the formula down the rest of the column applies it appropriately to the ...