google-sheetsspreadsheetarray-formulasfinance
How to use ARRAYFORMULA for REPLACE function in Google Sheets?
G'day, I'm working on a finance project using Google Sheets and I think I'm getting in a bit over my head.
I am trying to reformat a list of transactions by truncating the date (mm/dd/yyyy and a space) so that I can sort them alphabetically. I tried to do this quickly using an ARRAYFORMULA, but it did not seem to work as I wanted to. I'm using it in conjunction with the REPLACE formula:
=ARRAYFORMULA(REPLACE(A2, 1, 11, "")
I've made an spreadsheet here to exemplify the problem.
It doesn't throw an error, but it also doesn't generate a full array. I would be most grateful if someone could explain why this isn't working, or perhaps clarify the way ARRAYFORMULA function is supposed to work.
Thanks!
Solution
Try this
=Arrayformula(TRIM(REGEXREPLACE(A2:A,"^\S+","")))
- Is there any way to do a bitwise shift right on a very large number in Google Sheets?
- Auto numbering rows in GoogleSheet
- Error message while automating data entry from web app contact form to google sheet
- How do I send email to user by appending my domain name to the user name in Google Apps Script?
- How to split comma-separated values across multiple rows dynamically?
- Replace multiple strings in Google Spreadsheet with script
- How to count the amount of times a substring appears in a range of cells?
- Query with multiple data types
- Count If Range Matches Lookup in another tab
- Google Sheets Query where data in either of two columns matches the value in a cell populated by a multi-select dropdown
- Trying to combine words and math in a single cell in google sheets
- Counting the previous sample over multiple conditions throughout the range
- How to randomly select by type probability all items from a google sheet column range
- Sort result of function by RHS column
- Google Sheets Query - using another query to filter dates
- Skip formula if sheet does not exist in Google Sheets
- How to get data from public google sheet and more than 100 rows
- In Google sheets how can I Script the manipulation of the default Zoom?
- Google Sheets IMPORTDATA for xlsx files
- conditional formatting to highlight the highest value in a row compared to all the columns before it
- Google sheets summation formula, iterating until a new header on column A
- Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block
- How to scroll to bottom of a google spreadsheet using selenium
- Calculate average days between dates continuously updating
- Conditional formatting in Google Sheets is recognizing some cell values that equal 0, not others
- Model / Year formula fails when a sequence starts stops then starts again
- Google Sheets: Sumif formula
- Randomize cells in Google Sheets
- Google script for move rows depending on checkbox - Google sheet
- How do I splitTextToColumns only for cells containing commas in Google Apps Script?