The Student Room Group
Uni students - Complete our survey >>
Uni students - Complete our survey >>
Uni students - Complete our survey >>

This discussion is now closed.

Check out other Related discussions

Copying cells in Excel without including a term ""

Hello again



my query is as follows..

when using MS Excel or OO Calc how can you by using a formula copy data from one column say A to another say B, without including the word "GBP" in your copied column - But not by filtering, sorting, macro, plugin etc, just a formula, the simplest one without being too picky
Reply 1
Avatar for dhokes
dhokes
13
I don't know what you mean by not including the word "GBP" but if you want to copy the data from A1 then simply B1 (=A1) and then drag the formula down the rest of the column.
Reply 2
Avatar for _khan
_khan
OP
solved using TRIM, but thanks anyways
How did you solve it using TRIM? That just gets rid of unnecessary spacing. After a bit of fiddling I came up with =REPLACE(F2,SEARCH("GBP",F2),3,)
Where you can just put whatever cell you want copied instead of F2. I suppose if you had GBP as a word with spaces before and after you might want to put TRIM around it to neaten it up, and remove the extra space...
=TRIM(REPLACE(F2,SEARCH("gbp",F2),3,))

Related discussions

Latest

Trending

Trending

Articles for you