If cell starts with letter/contain word return the text to another cell

[Swiftkoala]

Hi All,

so what I'm trying to do is to return the text in A1 to L column, but only if it eithers

a) Starts with the letter (likely most ideal solution)
b) Contain specific words

I think both options might work, however I'm not sure how to proceed.

The catch is:

1) I want to return given text only up to the point where another row starts with the letter. At that point, I would like to have new value mirrored

2)Table is irregular, meaning sometimes I would need to return same value 3x and sometimes 5x

Could you help, please?

 

[Swiftkoala]

Oh, ok. I will find the tutorial for that! Thank you all for your guidance, it's much appreciated!

 

[jtakw]

Hi,

Could you possibly mean this?

Book3.xlsx
	A	B										L
1	Brazil
2	25th Feb 2021											Brazil
3	123											Brazil
4	456											Brazil
5	789											Brazil
6	Colombia
7	456											Colombia
8	789											Colombia
9	123											Colombia
10	258											Colombia
11	852											Colombia
12	654											Colombia
13	753											Colombia
14	159											Colombia
15	951											Colombia
16	Denmark
Sheet802

Cell Formulas
Range	Formula
L2:L16	L2	=IF(ISNUMBER(LEFT(A2)+0),IF(ISNUMBER(LEFT(A1)+0),L1,A1),"")

 

[Swiftkoala]

Hello Jtakw,

Your solution work great as well!. Thank you so much!

 

[jtakw]

You're welcome.