PDA

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