Copying over only limited number of characters

P

phuser

Hi

need the formula to bring over only 6 of the characters from 1 cell to
another,

I thought it was =Left (A1, [6]) but it doesnt work

what am I doing wrong?
 
P

phuser

Lol thank you sooooo Much

Feeling pretty stupid right now, but I truly appreciate

VBA Noob said:
Nearly there

Try =LEFT(A1,6)

VBA Noob
phuser said:
Hi

need the formula to bring over only 6 of the characters from 1 cell to
another,

I thought it was =Left (A1, [6]) but it doesnt work

what am I doing wrong?
 
Top