Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2022, 04:12 AM
karkey karkey is offline Need help Windows 10 Need help Office 2013
Novice
Need help
 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default Need help

Can a header and add a formula in excel file using vba



Header (e.g, Find, Change)

add formula as in the output file.
Attached Files
File Type: xlsx Input-file.xlsx (8.0 KB, 7 views)
File Type: xls Output-file.xls (32.0 KB, 10 views)
Reply With Quote
  #2  
Old 10-29-2022, 11:21 AM
karkey karkey is offline Need help Windows 10 Need help Office 2013
Novice
Need help
 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default Kindly help on this please

Kindly help on this please
Reply With Quote
  #3  
Old 10-30-2022, 07:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need help Windows 10 Need help Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please add some more explanation. your thread is as clear as your thread title, very obscure
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 10-30-2022, 07:10 AM
karkey karkey is offline Need help Windows 10 Need help Office 2013
Novice
Need help
 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default

Need to list files extension in like (*.eps, *.tif, *.jpeg) in provided path (any)

and add header above the list files as "Find" in Cell "A1" and "Change" in Cell "B1"

after that insert formula in Change Cell "A2", "A3", ... etc.

this formula to be insert: =INDEX({"IFig";"SFig";"Fig";"CFig"},MATCH(MID(LEFT (B3,FIND(".",$B3)-1),10,1),{"a";"s";"f";"c"},0)) & VALUE(MID(LEFT(B3,FIND(".",$B3)-1),11,2)) & MID(LEFT(B3,FIND(".",$B3)-1),13,99)
Reply With Quote
  #5  
Old 11-09-2022, 05:16 AM
karkey karkey is offline Need help Windows 10 Need help Office 2013
Novice
Need help
 
Join Date: Jan 2021
Posts: 19
karkey is on a distinguished road
Default

Kindly help me on this.
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft