ExcelBanter - How to retrieve character from a string for excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to retrieve character from a string for excel? (https://www.excelbanter.com/excel-discussion-misc-queries/108389-how-retrieve-character-string-excel.html)

Eric

How to retrieve character from a string for excel?

Does anyone know how to retrieve the first two character from a string for
excel?
such as there is a word in Cell B2 = "Choice", then in Cell B1, which
display only "Ch".
Does anyone have any suggestion?
Thank you for any suggestion
Eric

Stefi

How to retrieve character from a string for excel?

=LEFT(B2,2)

Regards,
Stefi

€žEric€ ezt Ã*rta:

Does anyone know how to retrieve the first two character from a string for
excel?
such as there is a word in Cell B2 = "Choice", then in Cell B1, which
display only "Ch".
Does anyone have any suggestion?
Thank you for any suggestion
Eric

All times are GMT +1. The time now is 02:10 AM.