Thread: Output cell limited to 20 characters

Hi, I'm trying to see if I can have my output file to only read and output the first 20 characters of a cell. For example:
P-47 Thunderbolt: Bolt From The Blue: American War
P-Star Workout DVD: Exercise Your Body And Mind
P.S. I Love You


these 3 outputs should be:
P-47 Thunderbolt: Bo
P-Star Workout DVD:
P.S. I Love You

(btw, the output doesn't have to be in one cell. it should be in 3 cells. like B1:B3 is the output and the source is A1:A3)

also, the "P.S. I Love You" is under 20 characters so it should output the same.

In B1, =Left(A1,20)

Sweet thanks!