Replace words or Delete characters partically

[RashmiM]

Hi,

Can anyone please help me in replace the below values (in rows) with space.
Actual it looks like :
[TABLE="width: 200"]
<colgroup><col width="200" style="width:150pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 200"]D[24954] Q1 [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]D[24955] Q2 [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]D[24956] Q3 [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]D[24957] Q4 [/TD]
[/TR]
[TR]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD="class: xl63"]D[24958] Q5

Expected is :
Q1
Q2
Q3
Q4[/TD]
[/TR]
</tbody>[/TABLE]

 

[konew1]

This formula will put the result into another cell. If you want to make the change in the original cell then you need VBA

=SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)),"")

 

[shg]

There are many ways you could do this, depending on how well your examples illustrate your actual data:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr][tr][td]

1​

[/td][td]D[24954] Q1 [/td][td]Q1[/td][td]B1: =TRIM(MID(A1,FIND("]", A1) + 1, 9))[/td][/tr]
[tr][td]

2​

[/td][td]D[24955] Q2 [/td][td][/td][td][/td][/tr]
[tr][td]

3​

[/td][td]D[24956] Q3 [/td][td][/td][td][/td][/tr]
[tr][td]

4​

[/td][td]D[24957] Q4 [/td][td][/td][td][/td][/tr]
[tr][td]

5​

[/td][td]D[24958] Q5 [/td][td][/td][td][/td][/tr]
[/table]

 

[RashmiM]

Hi,
Thanks for the reply.
Yes, i need the changed value in original cell itself .
Can you please help me with the required VBA?

Thanks

 

[RashmiM]

Thanks for the reply but i need the changed value in original cell itself.
Request you to help in this regard.

Thanks,
Rashmi

 

[mfexcel]

You may try FIND and REPLACE
1) Select the range of cells
2) Ctrl+H
3) Find what: *]space (note: not the word space, but an empty space)
4) Replace with: nothing (note: not the word itself)
5) Replace all

Thanks for the reply but i need the changed value in original cell itself.
Request you to help in this regard.

Thanks,
Rashmi