Well I want to add few numbers in a few number for example I have ten columns containing few cell numbers and i want to add 92 my country code with it. I have tried this by using replace formula but in result it comes in text format from which i cannot use another formula unless text format is removed and for that i have to do it one by on in every single cell. I have attached a sample sheet. Plz guide.
Hi,
Check the attached file, hope this will help you
sample for web.xlsx
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Try this in B1, copied down...
=--(92&A1)
You will probably need to format to general or fixed with no decimal places
@ Paresh, your formula gives a text result, which the OP said they did not want
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
Thanks Friend, You helped alot.Originally Posted by FDibbins
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks