In column A I have a listing of properties that are identified by locations such as:
US 1250.43 (Cell A2)
US 12473.56 (Cell A3)
US 432.45 (Cell A4)
I would like to set something up in column B where it would give me the listing for only what's to the left of the period.
ie. US 1250 (Cell B2)
US 432 (Cell B3)
How can I do this?
Try this
=LEFT(A2,FIND(".",A2,1)-1)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks OC! On the money!
Merry Xmas!
Merry Christmas to you too - 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