How to extract the first letter from Text？

For example

The initials of Text	Text
P	P2311HJKL
R	R2301OBY0
Z	Z2309NW0

Transformation

Accepted answers

With a formula tool you could use LEFT([Text], 1) to get the first character. It does not care whether it is a letter or symbol or number though.

All comments

With a formula tool you could use LEFT([Text], 1) to get the first character. It does not care whether it is a letter or symbol or number though.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703