madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello Folks
I am a rookie in excel macro. I need a macro to sort out my issue. If any cell contains text "Name" the letters or numbers before the 1st space should be deleted in the below cell. If anyone able to write code please help me. Thank you.
Before After[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Name
[/TD]
[/TR]
[TR]
[TD]Peter Siddle
[/TD]
[TD]Siddle
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am a rookie in excel macro. I need a macro to sort out my issue. If any cell contains text "Name" the letters or numbers before the 1st space should be deleted in the below cell. If anyone able to write code please help me. Thank you.
Before After[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Name
[/TD]
[/TR]
[TR]
[TD]Peter Siddle
[/TD]
[TD]Siddle
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]