Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 297
- Office Version
- 365
- Platform
- Windows
MS Excel 2007. I have an address data base in which Column J contains Zipcode in 6 digits. I have this Column J formatted under category "Text". For convenience I have entered only last 3 digits, for example 096 in J2.
My requirement: A formula for Column J. J2 displays 096. I want this to be prefixed with
600. The resultant output in J2 should be 600096.
My requirement: A formula for Column J. J2 displays 096. I want this to be prefixed with
600. The resultant output in J2 should be 600096.