Bug?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

am am trying to use the following code in a cell:

=LEFT(Sheet1!S1,2)&left(x,2-LEN(sheet1!S1))

it's designed to extract the first two characters from S1 on sheet1, but if
there are not two characters there, to use the first two from a cell named
'x'.
It works fine when the target cell starts with alphas, but fails if the
target cell has nemerics for the first 2 chacters. Appreciate any guidance.
 
Not sure what "fails" means to you, but if S1 contains more than 2
characters, the second part of your formula will return a #VALUE! error,
since you can't take a negative number of characters with LEFT()\

Seems to me you could use

=LEFT(Sheet1!S1&x,2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro not working in personal.xls 9
Remove Alpha Characters 39
Excel VBA help: Text file formatting 19
VBA set thick borders around non empty cells in range 0
Extracting a Part of a Formula as Text 5
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Clean this select case code up a bit. 2

Back
Top