Formula for removing periods and spaces before text

[bristolrob]

Good morning
I am looking for a formula that can remove periods and spaces before any text, but i want to keep the remaining periods and spaces in the string such as below

. .Nut M6 1/3 inch.
. . . .GPS module.
.... Cable assy

I would like to see

Nut M6 1/3 inch.
GPS module.
Cable assy

 

[Sufiyan97]

is that what you want?

Products.xlsx
	A	B	C
1
2	. .Nut M6 1/3 inch.	Nut M6 1/3 inch.
3	. . . .GPS module.	GPS module.
4	.... Cable assy	Cable assy
5
6
Sheet3

Cell Formulas
Range	Formula
B2:B4	B2	=MID(A2,AGGREGATE(15,6,SEARCH(CHAR(ROW($65:$90)),A2),1),99)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[bristolrob]

This formula works perfectly and accounts for all the potential variations, many thanks for your valuable time

 

[Sufiyan97]

You're welcome
Glad we could help!