Removing leading characters & spaces

[stuartgb100]

Hi,
It's been a while, but hoping you good people can help me again, please ....
I have a lot of data in col B which I've imported from a Word doc.
Problem data looks like this:
| 01
or something similar, but "|" is the problem.
When found, how can I remove it together with any following spaces ?
Many thanks.

 

[Joe4]

Can you please post a sample of your data, so we can see the fill extent of this, and what you data looks like exactly?

 

[stuartgb100]

Sorry.
Here's a sample:

Folder PATH listing for volume WAV - Target
Volume serial number is C632-D277
F:.
| output.doc
|
+---'70s Rock
| 01_Hotel California (2013 Remaster).flac
| 02_BLACK SABBATH - #Paranoid# (Official Video).flac
| 03_Queen - Bohemian Rhapsody (Official Video Remastered).flac
| 04_Dire Straits - Sultans Of Swing (Official Music Video).flac
| 05_Led Zeppelin - Stairway To Heaven (Official Audio).flac
| 06_Zoo - 'Layla' Top Of The Pops Derek & The Dominos.flac

Regards and thanks.

 

[hagia_sofia]

So, something like:

=TRIM(SUBSTITUTE(A1,"|",""))

 

[Joe4]

If it is always at the beginning, and always the same number of spaces, you could do a simple Find/Replace, replacing "| " with nothing, and then it would do them all at once, in place.

 

[stuartgb100]

If it is always at the beginning, and always the same number of spaces, you could do a simple Find/Replace, replacing "| " with nothing, and then it would do them all at once, in place.

Thanks both.
The formula works fine !
I understand the Find & Replace comment, but not run it yet.
Thanks again.
cheers.