Problem with Text function within formula

[Lee2791buck]

Hi All,

I'm having a brain problem trying to get a text function to work in a formula The formula is: =+"Drugname ("& K5 & ")" & "_" & TEXT(E5,”00000000”)

The idea is I will get a field populated like "Drugname (Brandname)_01234567". I need the text function to ensure that the number that is returned from e5 is added to my resultant string,

Basically a person will enter a brand name into field K5 and a number into E5 and the result is these concatonated into a string that then can be looked up in another spreadsheet, in this case the drugname is constant.

But it seems the Text wont work, dosent matter what I put into the e5 field.

I thought I'd done this before, thought it was simple but Im lost for ideas.

Any clues????

Thanks,

Lee.

​

 

[Fluff]

Hi & welcome to MrExcel.
In what way doesn't it work?

 

[Lee2791buck]

Sorry, I get a ?Name error, running the formula analysis says it works up to the text function

 

[Alex Blakenburg]

I could be mistaken but it looks to me that you have the slanted quote marks account the text format it needs the straight ones

 

[Lee2791buck]

I could be mistaken but it looks to me that you have the slanted quote marks account the text format it needs the straight ones

Really? I copied and pasted this from my useful formulae document, never had a problem. There double quotes ie shift 2. would it be single?

 

[Fluff]

No, they need to be double quotes but they should be like " and not ”
Just edit them in the cell & you should be ok.