Category: SEARCH
![Middle name + 1st name](https://xlfxs.com/wp-content/uploads/2024/02/b62f10d2-18fa-408c-9dc1-6453690f7945-1-360x270.jpeg)
Middle name + 1st name
ANmar February 3, 2024
![Cuts string of list of items](https://xlfxs.com/wp-content/uploads/2022/08/2009-01-22-Lessons-1-360x270.jpg)
Cuts string of list of items
ANmar August 17, 2022
![Always get 1st name (or last)](https://xlfxs.com/wp-content/uploads/2022/07/1stlast-e1658254291468-1-360x218.jpg)
Always get 1st name (or last)
ANmar July 23, 2022
![Worksheet name, dynamically using formula](https://xlfxs.com/wp-content/uploads/2018/04/Screenshot_1-1-e1522696825431-2.jpg)
Worksheet name, dynamically using formula
ANmar April 3, 2018
![Text-to-Columns, dynamically using formulas](https://xlfxs.com/wp-content/uploads/2018/04/Screenshot_1-4-360x270.jpg)
Text-to-Columns, dynamically using formulas
ANmar April 3, 2018
![Extract current (Active) workbook name](https://xlfxs.com/wp-content/uploads/2015/09/cellfilename-2-360x270.jpg)
Extract current (Active) workbook name
ANmar September 14, 2015
![Get column name (columnname as A,B,C, etc) as input inside cell](https://xlfxs.com/wp-content/uploads/2015/04/ColumnName-starting-from-certain-column1-e1543955211915-2-360x270.jpg)
Get column name (columnname as A,B,C, etc) as input inside cell
ANmar April 6, 2015
![Extract Address into table](https://xlfxs.com/wp-content/uploads/2012/02/S_0086_01-2.jpg)
Extract Address into table
ANmar February 10, 2012
![MID + SEARCH to convert cell to rows](https://xlfxs.com/wp-content/uploads/2012/01/Image1-2-360x270.jpg)
MID + SEARCH to convert cell to rows
ANmar January 23, 2012