Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi guys- pretty simple question I suppose for someone who knows their stuff.
I have a column of data which looks like this- A1: ,08-5x1,,49 A2: ,08-5x1,,56 A3: ,10-10x1,,50 A4: ,10-10x3,,26 A5: ,10-14x1,,46 A6: ,10-19x1,,32 Etc. As a result I need the second and third number to multiply together in a new cell. So the answer to above would be B1: 5 (5x1) B2: 5 (5x1) B3: 10 (10x1) B4: 30 (10x3) B5: 14 (14x1) B6: 19 (19x1) etc. I have tried to use the text to columns function but this fails to help in two regards- when you use the fixed width to separate the multipliers out into new cells, it wont work because some are single and some double digits. When I use a delimited TTC there are not enough delimiter options for me to separate out the data I need from everything else which is in there. I can get the answer in a couple of steps without a problem, but I am hoping to have one formula which will do this. What is the best way to do this? Any advice? Cheers, Chris. |
#2
![]() |
|||
|
|||
![]() Quote:
__________________
Asobi Wa Owari Da |
#3
![]() |
|||
|
|||
![]() Quote:
For future reference, if possible, could you explain above? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save-As Restriction | Excel Worksheet Functions | |||
VLOOKUP with a restriction | Excel Discussion (Misc queries) | |||
Sheet tab Restriction | Excel Discussion (Misc queries) | |||
ask for overtime with time restriction | Excel Discussion (Misc queries) | |||
add restriction in Excel | Excel Worksheet Functions |