LinkBack URL
About LinkBacks
In Cell AA we have a list of numbers - I want to add the word "[space]metres" after every number except for number "1" which I need "[space] metre" added, whats the easiest way to do this without manually adding the text?
In Cell AA we have a list of numbers - I want to add the word "[space]metres" after every number except for number "1" which I need "[space] metre" added, whats the easiest way to do this without manually adding the text?
=IF(AA1=1,AA1&" metre",AA1&" metres")
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Brilliant, that worked a treat, Ive also got another slight variant. In column F Ive got a list of skus which look similar to this - DEC-RAINB-0916-1
At the end of every one is a number from 1 to 50. I want to make it so that the single numbers (ie 1-9 still have two numbers so 01, 02, 03). Obviously if I do a simple find and replace it will mess up the two figure numbers too (ie find 1 and replace with 01 will also change the number 10 to 010). Is there an easy way around this?
Hi,
your last post being a new question and a different kind of problem, I would suggest you start a new thread so that everyone can make the most of the information - Thx
Thanks for the advice, Ive added the question here - http://www.excelforum.com/excel-prog...in-a-cell.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks