•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Change part of string based on table
I'm trying to replace the first two chunks of this string, based on a table, while keeping the rest the same. This table (E:F) will only contain the first two chunks of numbers. Is there a way to search part of the string and return a value, similiar to xlookup, but also keep that last part of the string the same without having that full unique value in the table?h
Edit: for clarification we're moving from 8 digits at the beginning of the GL code to 10 digits and the rest of the string is the same. What's in red is all that's changing. The reference table will only have those 8 and 10 digit characters. It's for about 2,000 lines
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#cloud-based spreadsheet applications
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#string manipulation
#GL code
#lookup
#8 digits
#10 digits
#replace
#E:F table
#data transformation
#reference table
#Excel formula
#chunk
#search