Copy/Paste Certain # of Characters

[TBeverson]

Does anyone know of a function that will copy only a specific # of characters from another field? For example, say I want to copy the first 45 characters of "NOW IS THE TIME FOR ALL GOOD MEN TO COME TO THE AID OF THEIR COUNTRY". That means I only want to copy "NOW IS THE TIME FOR ALL GOOD MEN TO COME TO T". Is there an easy way to do this? Thanks in advance for any assistance!

[StephenR]

You could use the LEFT formula, viz:

=LEFT(A1,45) where A1 has your phrase.

[TBeverson]

Awesome, that worked! Thanks so much.

[sirlink]

I have a similar Question.
Same sinareo except i would only would like to return compete values.
IE 45 characters of
NOW IS THE TIME FOR ALL GOOD MEN TO COME TO THE AID OF THEIR COUNTRY
return value lossing the dangling character of the truncated word.
NOW IS THE TIME FOR ALL GOOD MEN TO COME TO