•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I want to search a row E for some text of variable length but always starting with the same "NNN-MMM" and populate column A with this text
Can anyone please help me with a formula for the above? I want the cells of column A to populate with the text starting with "NNN-MMM". I need to search the corresponding cell of column E for this text. Please see the picture to illustrate what I mean:
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#Excel compatibility
#row zero
#NNN-MMM
#formula
#search
#text
#column A
#column E
#populate
#cells
#corresponding cell
#help
#variable length
#data