edit cell value 1

[faxof]

i have a column containing codes in the following format:
"GB123456D"
i want to remove the GB part for each entry.

any ideas?
faxof

 

[SQLBI]

Faxof,

If the ref's are always the same length use:

=RIGHT(CellRef, 7)

If they vary in length use:

=RIGHT(CellRef,LEN(CellRef)-2)

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[Bowers74]

You could also try:

=SUBSTITUTE(A1,LEFT(A1,2),"&quot

This assumes also that the references are always 2 characters long.

Hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!