removing position numbers

[thesilkster]

Good morning i am trying to remover numbers from an export data sheet

Column B
Name
1. Carl Ritson
2. Paul Smith
123. Dave Anderson

It should be

Column B
Name
Carl Ritson
Paul Smith
Dave Anderson

i have tried using trim but the placing for that week could be from first place 1. to next week could be 130.



any help is most appreciated thanks

 

[AVK]

Hello thesilkster :
You can select data which you have remove.
Then press : Ctrl "F" (Find)
In Find What : mentioned *.
Select : Replace & click on Replace All

Good morning i am trying to remover numbers from an export data sheet

Column B
Name
1. Carl Ritson
2. Paul Smith
123. Dave Anderson

It should be

Column B
Name
Carl Ritson
Paul Smith
Dave Anderson

i have tried using trim but the placing for that week could be from first place 1. to next week could be 130.

View attachment 11480

any help is most appreciated thanks

 

[Asheesh]

@thesilkster
If you need a formula then you may want to try - TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),LEN(SUBSTITUTE(A1," ",REPT(" ",99)))-99))

Suppose your data is A1 then put this formula in B1

Regards
Asheesh

 

[NARAYANK991]

Hi ,

Another option :

=MID(A1,FIND("|",SUBSTITUTE(A1," ","|",1))+1,999)

Narayan

 

[thesilkster]

Thank you Narayan you are a legend you are most helpfull

 

[shrivallabha]

Just one more formula crunch.
=TRIM(RIGHT(SUBSTITUTE(A8," ",REPT(" ",99),1),99))