If I create a sum in a cell eg. =sum(f47:f55), is there any way to look at this cell and extract the start column, start row, end column and end row into cells?
In this example:
start column would be F
start row would be 47
end column would be F
end row would be 55
I've looked at various ways of cutting up the text but wondered if there was some calculation which may just extract thes items for me
I don't mind if the results have to be in individual cells - just need to extract them somehow
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.