Solved: Left Function [Archive]

View Full Version : Solved: Left Function

Nurofen

11-13-2007, 10:03 AM

Hi,
I'm trying to put text from column A in to another cell with the first to characters of column C.

=a1, =left(c1,2) into one cell say D1

Thank you for your time

Nurofen

sorinvoinea

11-13-2007, 10:09 AM

check help for the Mid function (type mid in the vba editor and press F1).
and also you could check the InStr one.:thumb

Nurofen

11-13-2007, 10:30 AM

Thanks for that but how do i hold the whole value of A1

A1=cat
C1=123456

=A1 =mid(c1,1,2)

=cat12

thank you for your time

Nurofen

Nurofen

11-13-2007, 10:35 AM

Got it

Thanks sorinvoinea

A1=cat
c1=123456

=mid(a1&c1,1,5)

=cat12

Nurofen :thumb

Bob Phillips

11-13-2007, 10:46 AM

That should be

=A1&LEFT(C1,2)

Nurofen

11-13-2007, 11:10 AM

Nice one Xld I was just about to post back.

Thats what i needed :thumb

Thank you for your Time

Nurofen