Similar headers exist but not able to remove/rename and keep correct header

[PC2016]

I am exporting information from different versions of a schematic program in tab delimited text that will be imported back into the schematic. Over the years/versions some of the header information has changed slightly. I need to search for the preferred header, if it exists I want to keep it (do nothing) but remove the other similar headers. If it doesn't exist, I would like to search for the similar name and rename it if it exists.

I have no code that makes sense enough to post.

Header example: PL Position vs. PL_Position
The underscore header is the preferred header.

[humdingaling]

without actual data or structure to go by

can you not just substitute " " with "_"

[PC2016]

I could do that but in some cases I will have both properties existing in the same export file. I would like to test for the duplicate and remove one if there are two, or rename if the one exists but is not the underscored version.

[humdingaling]

can you post some sample data so i can see what your dealing with

[PC2016]

Part of the issue is that sometimes the property will not exist at all. I need to search for three possibilities: does not exist (then add it), exists but not named correctly (BAAN Position) and rename (BAAN_Position), exists and correct - continue to next sub. I have been trying to figure out the ElseIf but not sure if that is the best way. This is the partial working code but still need the if not there part.

CODE
Sub M4A_Rename_BAANPosition()
'
' Find the BAAN Position column and Rename
'
Dim BAAN_Position As Boolean
BAAN_Position = True
'
Sheets("BAAN_BOM_From OrCAD").Select
If BAAN_Position = False Then
Range("BAAN Position").Select
Cells.Replace What:="BAAN Position", Replacement:="BAAN_Position", LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Else
Call M4B_Find_BAAN_Position_Add_formula
End If

End Sub

[humdingaling]

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

what exactly is BAAN_Position meant to be ? a named range?

ps you have set BAAN_Position to True so it will always go to Else?