I had an issue last week, http://www.excelforum.com/excel-form...ml#post4114927 which solved the problem. Now I have two with alpha characters. I changed "='Facilities(TC331)'!H7&2" to "=--('Facilities(TC331)'!H7&2)" and now it works. How do I make that work for alpha/text?
Last edited by thecdnmole; 06-30-2015 at 05:27 PM.
Would you be so kind as to ask your question in this thread?
Entia non sunt multiplicanda sine necessitate
I added a bit to my OP. Hope that helps?
Maybe you could provide an example and describe the desired result.
Sure, here is the original from the other day and the new numeric formula I learned about. Problem is I have four numbers with an "A" and "B" in them. Now this new formula does not work for them. I could just change the "A" for a "1", but in a number such as 8235a looks better than 82351.
What's wrong with the formula in B1?
What problem are you trying to solve?
I am using the formula on sheet2, column E. This works for the values in sheet2("B2:B3"), but not in B4 because of the alphabet. So, my question is, how do I use the formula with the alpha value as in B4? I need something that works for both.
Row\Col new formula 83851 E2: =B2 & COUNTIF($B$2:$B2,B2) 83861 8385a1
All you did was put a space in front and behind the "&"? I had to change all the formula to similar "text" style and now it appears it's working! Thanks shg!
Last edited by thecdnmole; 07-01-2015 at 11:47 AM.
The white space is just for legibility -- it's ignored by Excel. It's the elimination of the --, which converts a numeric string to a number, that was causing problems.
Hmm, I need to study this more because that was my initial problem, not all cells and formula was in same format, thus the -- put it that way, as well as using the formula would put it in one form and if you had to manually enter the cell info would put it in another format. On the sample sheet it does appear to work.
Well I don't get it. I am back to my original formula and it's working! That is why I started the previous post because this formula did not work in all situations. Gotta love Excel quirkiness!
Excel has it's quirks, but this isn't one. It won't work if there is an alpha character in the number.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks