return just part of string

Mar 12th, 2002, 02:39 PM

How do I return just say the fist 5 characters in a string? I would like to return them as a string themselves.

Aladin Akyurek · Mar 12th, 2002, 02:40 PM

Quote:

On 2002-03-12 13:39, Anonymous wrote:
How do I return just say the fist 5 characters in a string? I would like to return them as a string themselves.

=LEFT(A1,5)

where A1 houses a target string.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 02:39 PM	#1
Guest Posts: n/a	How do I return just say the fist 5 characters in a string? I would like to return them as a string themselves.