LinkBack URL
About LinkBacks
Hello. I see this formula for combining numbers in a cell ="("&B2&")"&C2 Two questions: 1) I never understand the purpose of & and the "". WHy Do I need two "" to start off this formula? Also, how can I add a space after the second parentheses?
Hello. I see this formula for combining numbers in a cell ="("&B2&")"&C2 Two questions: 1) I never understand the purpose of & and the "". WHy Do I need two "" to start off this formula? Also, how can I add a space after the second parentheses?
Add a space after the second parentheses and before the quotation mark, that will give you the space you require. As for the Quotes, the first set tells it to place a () around the number, without it, you wont get the (). The second set tells it to put in the value of cell B2. If you don't have the second set of quotes, it will place &b2& in the () instead of the value.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
="("&B2&")"&C2
( is text, and you need to wrap all text in "" when used in a formula - plus you are combining that with (potentially) a number in B2
B1=50
C2=days
Days (50)Days
D2=="("&B2&")"&C2
To add that space after the 2nd ) just include it inside the ""...
="("&B2&") "&C2
Days (50) Days
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Got it. Thanks.
you are welcome, thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks