if left value =

[ammartino44]

Hello. Why doesn't this work?

Please Login or Register  to view this content.

[oeldere]

you use the wrong syntax for the left formula.

[JOHN H. DAVIS]

For one thing cell is a range.

Please Login or Register  to view this content.

[ammartino44]

So, cell is a range, but then what does cell equate to in the Left(cell,1). Does it return the row number? IT seems like it must since 1 relates to the column.

I imagined that cell would equate to the first cell in the list. For example A2 and then left(A2).value should take the first number in that cell.

What about this?

Please Login or Register  to view this content.

End Sub

[ammartino44]

It seems like the .value messes it up. Not sure why. Anyway, @ Johnny D, it worked. Thanks.

[JOHN H. DAVIS]

For the Left Function the one indicates the character. You're welcome, glad to help out.

[oeldere]

a1 is Wheel

Left(a1,1) gives the result W

Left(a1,3) gives the result Whe

Hope I explained well enough.

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.