Hi guys
In cell A1, I have 2 lines of data. However, it will always start with: Last Updated:
Can someone advise on a formula, that basically instructs excel to return all the text AFTER 'Last updated:'?
Thank you!
Hi guys
In cell A1, I have 2 lines of data. However, it will always start with: Last Updated:
Can someone advise on a formula, that basically instructs excel to return all the text AFTER 'Last updated:'?
Thank you!
Thanks,
R.
Try the SUBSTITUTE function ( substitute your string with "")
You could do this:
=SUBSTITUTE(A1,"Last updated: ","")
Change the A1 to the cell that contains the data. Note that I have included a space after Last updated:, as I would expect that you have one there.
Hope this helps.
Pete
Hi Pete,
This is returning the cell containing the data, not the data/text after 'Last updated:'?...
thank you
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
still no luck Pete.
See cell A43 on the first tab, sheetattached (downloaded to excel from google sheet, using an import range)
There is nothing that says "Last updated:" You have numbered updates like "1st update:", "2nd update:" and so on.
Pete
sorry that tab is supposed to be hidden! try the 2nd tab (Admin snapshot) thank you! cell a43
Change the formula in A43/44 to this:
=SUBSTITUTE(A54,"Last Updated: ","")
Your formula was looking at cell A51.
Hope this helps.
Pete
cheers pete!
I am thinking that since the text always starts with "Last Updated: ", and since the desired text to retrieve appears to always be less than 100 characters long, that this formula would be "simpler"...
=MID(A54,15,99)
Of course, the 99 could be increased if the text could possibly be longer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks