Thread
:
Placing Col & Row identifiers into a cell as text
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Dave
external usenet poster
Posts: 1,388
Placing Col & Row identifiers into a cell as text
Hi John,
Try this:
=RIGHT(CELL("address",Sheet2!A1),4)
This gives the last 4 characters, which eliminates the unwanted stuff.
Regards - Dave
Reply With Quote
Dave
View Public Profile
Find all posts by Dave