Excel Help Please

dmg24

Can I ask for some help with Excel please?!

I am trying to set up a rule for the following: If I enter certain text in one column, I wish for it to automatically copy into another column.

Does that make sense?! I can do it in other columns, but not something I have tried in Excel before.

Thanks in advance!

jessicamb

in the column you wish to copy to you can put =cell eg =a1 would return whatever was in cell a1.

ManAtHome

If you only want text (no numbers) use (eg) IF(ISTEXT(A1),A1,"") (in cell B1)

dmg24

Thanks guys,

ManAtHome, that's just what I needed x

Lakeuk

ManAtHome wrote: »

If you only want text (no numbers) use (eg) IF(ISTEXT(A1),A1,"") (in cell B1)

Put following in cell B1 which will look at cell A1

=IF(A1="MYTEXTMATCH",A1,"")

replace MYTEXTMATCH with the phase you're wanting