Formula Challenge: Need a formula to pull a string of numbers after a specific character

[mrkmcdo]

Hi All,

First post!

I have a challenge to try and pull a string of numbers from a string of text that appears after a certain character.

Hopefully some smart guys out there can help.

Challenge:

The picture below shows the ideal outcome in Column A (Campaign ID)

SalesInvoices_Primal_Thailand_2020-Dec-21_05_19_39.png

The formula in Column A would search the Column D find the "#" then pull the 5 numbers after it into Column A regardless of position in the string found in Column D.

If someone can help to provide two solutions (1) formula that pulls the 5 numbers and includes the "#" and (2) formula that pulls the 5 numbers that is without the "#"

Much appreciated!

Attached the working file.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[mrkmcdo]

Attached, thanks!

[Pepe Le Mokko]

Any chance of posting an xlsx file instead of xls?

[BMV]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[mrkmcdo]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Works perfectly thank you.