ExcelBanter - Copying over only limited number of characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copying over only limited number of characters (https://www.excelbanter.com/excel-discussion-misc-queries/118031-copying-over-only-limited-number-characters.html)

phuser

Copying over only limited number of characters

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?

VBA Noob

Copying over only limited number of characters

Nearly there

Try =LEFT(A1,6)

VBA Noob
phuser wrote:
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?

phuser

Copying over only limited number of characters

Lol thank you sooooo Much

Feeling pretty stupid right now, but I truly appreciate

"VBA Noob" wrote in message
oups.com...
Nearly there

Try =LEFT(A1,6)

VBA Noob
phuser wrote:
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?

All times are GMT +1. The time now is 11:12 AM.