good morning all,
i have a column full of data that i need to put into another cell.
Only there is no set parameter other than its after the first 3 letters and a space and dont know how to extract it
i need the number after the first 3 letters and a space from cell c3 to go into cell p3
here is an example - c3=Chp 6Gd C4Hc 4K should then send 6 to P3
and another c3=Bat 5.5Fm C62yMd 1K should then send 5.5 to p3
if anyone could help id be very grateful
Bookmarks